#252 — April 18, 2018 |
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. |