#246 — March 7, 2018

Read on the Web

Postgres Weekly

CREATE STATISTICS, The Postgres 10 Feature You Didn't Know About — One key way Postgres’s planner chooses how to handle a query is through statistics it has collected. In some cases you could make things more efficient by telling Postgres to collect the right statistics, and this is where CREATE STATISTICS comes in.

Samay Sharma

PostgresConf US 2018: One Month Until National — PostgresConf US 2018 is around the corner. We are counting down the days until April 16 - 20 at the Westin Jersey City Newport, where hundreds of people from around the globe will be experiencing the largest Postgres conference event in North America.

PostgresConf.org sponsor

pgmetrics: Get Statistics from Live Postgres Servers — Aims to be “the simplest way to collect comprehensive information and statistics from a running PostgreSQL cluster”. It’s open source & available now. Homepage & GitHub repo.


PostgreSQL Meltdown Benchmarks — In January, people were worried about the performance effects of fixes for the Meltdown and Spectre vulnerabilities. Now, however, have come some deeper benchmarks for Postgres showing the impact isn’t as bad as first thought and is as potentially small as 5%.


zheap: A Storage Engine to Better Control Bloat? — zheap can prevent bloat by allowing in-place updates and reusing space as soon as a transaction that has performed a delete or non-in-place update has committed. It’s being proposed as a feature for Postgres 12.

Amit Kapila

Postgres 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22 Released — Billed as the March Security Update Release, these releases mitigate CVE-2018-1058, a vulnerability describing how a user can create like-named objects in different schemas that can change the behavior of other users’ queries and cause unexpected or malicious behavior.


Go Deep into Today’s Modern Data Tier to See the Root of the Problem Fast

SelectStar sponsor

PGDay UK 2018 (July 3, London) Call for Papers Open — The deadline for submissions is March 31 2018.


pgcli 1.9.0 Released — A command line interface for Postgres with auto-completion and syntax highlighting. This release adds \pset pager and \T to control output, as well as --list-dsn.

Irina Truong

Detecting Performance Problems with pg_stat_statements — An official PG module that can track execution statistics of all queries executed by a server.

Hans-Jürgen Schönig

Postgres 10: A Great New Version for a Great Database

Reuven M. Lerner

Linux Cloud Hosting Starting at 1GB of RAM for $5/mo

Linode Cloud Hosting sponsor

Golden Oldies ✨

BRIN Indexes in Postgres 9.5

Sortable Engineering

▶  Temporal Data Structures with SQLAlchemy and Postgres

Joseph Leingang