---
title: "#246: The Postgres 10 feature you didn't know about"
publication: "Postgres Weekly"
issue: 246
published_at: "2018-03-07"
canonical_url: "https://postgresweekly.com/issues/246"
---

The latest Postgres news, articles, tools, and projects.       

#246 — March 7, 2018 

[Read on the Web](https://postgresweekly.com/issues/246)   

Postgres Weekly  

[CREATE STATISTICS, The Postgres 10 Feature You Didn't Know About](https://www.citusdata.com/blog/2018/03/06/postgres-planner-and-its-usage-of-statistics/) — 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   [![\](https://copm.s3.amazonaws.com/a3fd7dd0.png)](https://www.postgresconf.org/conferences/2018) 

[PostgresConf US 2018: One Month Until National](https://www.postgresconf.org/conferences/2018) — 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](https://www.opsdash.com/blog/announcing-pgmetrics.html) — Aims to be _“the simplest way to collect comprehensive information and statistics from a running PostgreSQL cluster”_. It’s open source & available now. [Homepage](https://pgmetrics.io/) & [GitHub repo.](https://github.com/rapidloop/pgmetrics) 

OpsDash   

[PostgreSQL Meltdown Benchmarks](https://blog.2ndquadrant.com/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%. 

2ndQuadrant   

[zheap: A Storage Engine to Better Control Bloat?](http://amitkapila16.blogspot.com/2018/03/zheap-storage-engine-to-provide-better.html) — 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_.](https://www.postgresql.org/message-id/CAA4eK1%2BYtM5vxzSM2NZm%2BpC37MCwyvtkmJrO_yRBQeZDp9Wa2w%40mail.gmail.com) 

Amit Kapila   

[Postgres 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22 Released](https://www.postgresql.org/about/news/1834/) — 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. 

PostgreSQL.org   

[Go Deep into Today’s Modern Data Tier to See the Root of the Problem Fast](https://selectstar.io/root/?utm_source=CooperPress&utm_medium=Brief+Link&utm_campaign=Postgres+Weekly+Brief+Link+Mar7) 

SelectStar sponsor   

[PGDay UK 2018 (July 3, London) Call for Papers Open](http://www.pgconf.uk/papers) — The deadline for submissions is March 31 2018. 

2ndQuadrant   

[pgcli 1.9.0 Released](https://www.pgcli.com/v1.9.0.html) — 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](https://www.cybertec-postgresql.com/en/detecting-performance-problems-easily-in-postgresql/) — 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](http://www.linuxjournal.com/content/postgresql-10-great-new-version-great-database) 

Reuven M. Lerner   

[Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-brief) 

Linode Cloud Hosting sponsor   

Golden Oldies ✨  

[BRIN Indexes in Postgres 9.5](http://dev.sortable.com/brin-indexes-in-postgres-9.5/) 

Sortable Engineering   

▶[Temporal Data Structures with SQLAlchemy and Postgres](http://pyvideo.org/pycon-us-2017/temporal-data-structures-with-sqlalchemy-and-postgres.html) 

Joseph Leingang          

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom