#252 — April 18, 2018

Read on the Web

Postgres Weekly

Postgres's High-Volume Processing Developments — A great run down of the major performance improvements in recent Postgres releases (9.5 through 10, plus speculation about Postgres 11) and what each means.

Adrien Nayrat

Top Backup Tools for Postgres — A look at some backup methods you can use including Barman, BART and pgBackRest.

Viorel Tabara

AlwaysOn Multi-Master Replication for Distributed PostgreSQL — Postgres-BDR from 2ndQuadrant presents true high availability with point-in-time recovery. BDR provides rolling upgrades, with zero downtime, for geographically distributed PostgreSQL databases.

2ndQuadrant PostgreSQL Products sponsor

'Covering Indexes' Coming to Postgres 11 — You’ll be able to include extra, non-key columns into indexes as a way to allow more queries to benefit from index-only scans.

Michael Paquier

Ten Tips for Going into Production with Postgres — A variety of tips and tricks (be aware that a few lean heavily on Severalnine’s ClusterControl tool) for going into production including testing with pgbench, moving your WAL to a new disk, and using HAProxy for load balancing.

Achilleas Mantzios

pgAdmin 4 v3.0 Released — The popular open source management and admin tool gains a variety of usability improvements.

PostgreSQL

Postgres 11 Partition Pruning Performance — Two new patches have landed to improve the performance and usability of the declarative table partitioning feature introduced in Postgres 10.

David Rowley

PGConf UK 2018 (London, July 3) — The UK’s dedicated Postgres annual user conference returns soon.

2ndQuadrant

PostgreSQL Data Types: Date and Time Processing — A dive into a set of examples to help you get started with time based processing in Postgres.

Dimitri Fontaine

A Guide to Pgpool for Postgres: Part One — Pgpool is a useful tool for connection pooling and load balancing.

Vladimir Svedov

Index Maintenance: Get Rid of Your Unused Indexes — Why unused indexes are a hinderance, and how to find them.

Laurenz Albe

PostgreSQL Data Types: Network Addresses — Postgres includes support for cidr, inet, and macaddr data types. Here’s how to use them.

Dimitri Fontaine

Training Day Announced: DBA Skill Builder at Postgres Vision

Postgres Vision 2018 sponsor

Pgpool-II 3.7.3, 3.6.10, 3.5.14, 3.4.17 and 3.3.21 Released — Bug fixes.