--- title: "This Week's PostgreSQL News (#196)" publication: "Postgres Weekly" issue: 196 published_at: "2017-03-01" canonical_url: "https://postgresweekly.com/issues/196" --- Postgres Weekly 196 . [Read this on the Web](http://postgresweekly.com/issues/196) [Postgres Weekly](http://postgresweekly.com) Issue 196 — March 1, 2017 [A Deep Dive Into Postgres Stats with pg_stat_database](http://blog.postgresql-consulting.com/2017/02/deep-dive-into-postgres-stats_28.html?utm_source=postgresweekly&utm_medium=email)Alexey digs deeper into many of the catalog tables and stats that are already recorded, including cache hit ratio, deadlocks, and load. Alexey Lesovsky [Experimenting with Scaling and Full Parallelism in Postgres](http://www.cybertec.at/experimenting-scaling-full-parallelism-postgresql/?utm_source=postgresweekly&utm_medium=email)Some of the issues behind scaling Postgres to querying tables containing huge numbers of rows. Hans-Juergen Schoenig#tutorial [Benchmarking Query Parallelization on a 72 Core Machine](https://blog.2ndquadrant.com/parallel-monster-benchmark/?utm_source=postgresweekly&utm_medium=email)Postgres 9.6 added support for parallelizing some query operations and armed with a 72 core server, David Rowley set out to see if all 72 cores would come in handy. David Rowley#opinion [One-Click PostgreSQL for production, by Clever Cloud](https://www.clever-cloud.com/postgresql?utm_source=newsletter&utm_campaign=cooperpress-sponsored-link-early2017#3&utm_medium=email&utm_content=postgresql)Clever Cloud is a Polyglot and scalable PaaS, saving thousands of souls from server management since 2010. Host your data with a rock-solid PostgreSQL for production in Canada or Europe. Clever Cloud#sponsored[![\](https://copm.s3.amazonaws.com/8d93b41f.png)](https://www.clever-cloud.com/postgresql?utm_source=newsletter&utm_campaign=cooperpress-sponsored-link-early2017#3&utm_medium=email&utm_content=postgresql) [New Postgres 10 Features: Logical Replication & Partitioning](http://www.3manuek.com/postgres10logrepypart?utm_source=postgresweekly&utm_medium=email)We’re still months away from Postgres 10, but the likely headline feature is already known: logical replication and partitioning. Emanuel Calvo [Eliminating a 2nd Seq Scan When Deriving A New Table](http://dba.stackexchange.com/questions/164605/how-do-i-eliminate-a-second-seq-scan-over-a-table-when-deriving-a-new-table?utm_source=postgresweekly&utm_medium=email).. is slower than accepting the second table scan (unless the table can’t fit into memory). Stack Exchange [Generating Custom Sequences in Postgres](https://viccherubini.com/2017/02/25/generating-custom-sequences-in-postgres/?utm_source=postgresweekly&utm_medium=email)Sequences are used by default in Postgres for primary keys, but as highlighted here there’s more you can do with them if needed (in certain use cases such as common with multi-tenant apps). Vic Cherubini [General Availability for EDB Postgres Platform 2017](https://www.enterprisedb.com/news/enterprisedb-sets-new-standard-for-digital-business-with-edb-postgres-platform-2017?utm_source=postgresweekly&utm_medium=email) EnterpriseDB#news [Modeling Status Updates on PostgreSQL using JSON](https://medium.com/trisfera/modeling-status-updates-on-postgresql-using-json-b755acecf040?utm_source=postgresweekly&utm_medium=email)Taking advantage of PostgreSQL’s support of JSON to overcome a traceability constraint. Alexis Hevia#tutorial [Improving Linux System Performance with I/O Scheduler Tuning](https://blog.codeship.com/linux-io-scheduler-tuning/?utm_source=postgresweekly&utm_medium=email)Adjusting a Linux I/O scheduler to get the best performance and then measuring the impact of those changes with`pgbench`. Ben Cane#tutorial [Calculating Summaries with Histogram Frequency Distributions in SQL](http://www.silota.com/docs/recipes/sql-histogram-summary-frequency-distribution.html?utm_source=postgresweekly&utm_medium=email) Silota inc#tutorial [Get Instant REST APIs for Postgres](https://www.dreamfactory.com/signup?utm_campaign=signup-03-01-17&utm_content=postgresweekly&utm_medium=external-cooper&utm_source=email&utm_term=postgresql)DreamFactory turns your Postgres database into a comprehensive REST API. Free and open source, [try it now](https://www.dreamfactory.com/signup?utm_campaign=try-it-now-03-01-17=postgresweekly=external-cooper=email=postgresql). DreamFactory#sponsored [Pgx: A Pure Go Postgres Client Library](https://github.com/jackc/pgx?utm_source=postgresweekly&utm_medium=email) Jack Christensen#code [pg-large-object: 'Large Object' Support for Postgres in Node](https://www.npmjs.com/package/pg-large-object?utm_source=postgresweekly&utm_medium=email)Store files/objects up to 4 TiB in size. Joris van der Wel#code Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/196) [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