---
title: "This Week's PostgreSQL News (#184)"
publication: "Postgres Weekly"
issue: 184
published_at: "2016-11-30"
canonical_url: "https://postgresweekly.com/issues/184"
---

Postgres Weekly 184   . 

[Read this on the Web](http://postgresweekly.com/issues/184) 

[Postgres Weekly](http://postgresweekly.com) Issue 184 — November 30, 2016     

[On The Impact of Full-Page Writes](http://blog.2ndquadrant.com/on-the-impact-of-full-page-writes/?utm_source=postgresweekly&utm_medium=email)It’s worth knowing what full page writes do because their impact on performance can be significant and you can tweak Postgres to use them (or not). Tomas Vondra [Parallel Queries and SERIALIZABLE Transactions](http://www.cybertec.at/2016/11/parallel-queries-serializable-transactions/?utm_source=postgresweekly&utm_medium=email)With parallel queries many workloads can be speeded up considerably. But there are some limitations as highlighted in this post. Hans-Juergen Schoenig [Metrics Maven: Creating Pivot Tables in PostgreSQL Using Crosstab](https://www.compose.com/articles/metrics-maven-creating-pivot-tables-in-postgresql-using-crosstab/?utm_source=cooper&utm_medium=newsletter&utm_content=postgres)We show you how to use crosstab function in PostgreSQL to create a pivot table with aggregate values. compose#sponsored[![\](https://copm.s3.amazonaws.com/b5d44ec6.png)](https://www.compose.com/articles/metrics-maven-creating-pivot-tables-in-postgresql-using-crosstab/?utm_source=cooper&utm_medium=newsletter&utm_content=postgres) [CHAR(16) Conference: A Data Scalability Event in NYC (Dec 6)](http://charconference.org/?utm_source=postgresweekly&utm_medium=email)Showcasing the significant developments the leading PostgreSQL engineering teams have made in the areas of clustering, high availability and replication. Char Conference#news [Getting Time Zones Right When Setting Up Monthly Partitioning](https://blog.ondevice.io/databases/2016/11/28/postgres-partitioning.html?utm_source=postgresweekly&utm_medium=email)Timestamptz (with timezones) is often the superior datatype for timestamps in Postgres, but in some cases such as when partitioning data it’s not always the best. Learn more about what you should think about as you partition data by time here. ondevice.​io [Statically Typed PostgreSQL Queries in TypeScript](http://cs.mcgill.ca/~mxia3/2016/11/18/Statically-typed-PostgreSQL-queries-and-typescript-schemats/?utm_source=postgresweekly&utm_medium=email)A new approach towards implementing statically typed, PostgreSQL-backed services in Node using Typescript, pg-promise, and Schemats. Meng Xuan Xia#tutorial [Connecting to Postgres with database/sql in Go](http://www.calhoun.io/connecting-to-a-postgresql-database-with-gos-database-sql-package/?utm_source=postgresweekly&utm_medium=email)A tutorial showing how to connect to a Postgres database using database/sql and lib/pq, including potential errors and solutions. Jon Calhoun#tutorial [Postage: A Fast Replacement for PGAdmin](https://github.com/workflowproducts/postage?utm_source=postgresweekly&utm_medium=email)Version 3.1.0 is fresh out. Workflow Products#code [A Multi-Tenancy Journey with Postgres Schemas and Apartment](https://influitive.io/our-multi-tenancy-journey-with-postgres-schemas-and-apartment-6ecda151a21f?utm_source=postgresweekly&utm_medium=email)Using the definition of multi-tenancy as one tenant’s data not interacting with another’s is straight forward. Here's some of the trade-offs of approaches in implementing this. Brad Robertson [PostgreSQL Page Layout: How Data is Stored in Pages](https://www.8kdata.com/blog/postgresql-page-layout/?utm_source=postgresweekly&utm_medium=email)A walk through the details of how data actually gets stored on disk by Postgres. 8KData [Real-time Event Aggregation at Scale using Postgres with Citus](https://www.citusdata.com/blog/2016/11/29/event-aggregation-at-scale-with-postgresql/?utm_source=postgresweekly&utm_medium=email)Citus is an extension that lets you scale out Postgres. This post walks you through how you can deal with real-time aggregations of event data, using select into with distributed roll-ups. Citus Data [One Application, 4,000+ Opportunities - Try Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Finding the right role can be daunting, but not on Hired. Get empowered to find the right role with multiple job offers and free personalized support. Hired#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/184) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK