#246 — March 7, 2018
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.
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.
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 .
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.
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
Detecting Performance Problems with pg_stat_statements — An official PG module that can track execution statistics of all queries executed by a server.
Reuven M. Lerner