#220: Plans for Partitioning in Postgres 11

.

Read this on the Web

Postgres Weekly Issue 220 — August 16, 2017

PostgreSQL 2017-08-10 Security Update Release Updates to 9.2-9.6 for three vulnerabilities, explained in depth here. There’s also an end-of-life warning for Postgres 9.2 for which support will end next month. postgresql.​org   #news  Plans for Partitioning in v11 Postgres 10 has some key partitioning improvements, but there are already plans afoot for more in the eventual Postgres 11. Robert Haas PostgreSQL 10 Beta 3 Released Postgres 10 is almost here and the latest beta contains numerous fixes to beta 2. postgresql.​org   #news  Barman: Backup Strategy and Disaster Recovery Manager from 2ndQuadrant Do you have a recovery plan in place for when disaster strikes? More importantly, when's the last time you tested it? Don't risk severe data loss or down-time. Be proactive: Discover how Barman & 2ndQuadrant can help secure your critical databases. 2ndQuadrant PostgreSQL Products    #sponsored  Postgresql.org's FTP Server Shut Down Everything’s still available over HTTPS, but things have (mostly) moved on from FTP these days. Magnus Hagander   #news  PGConf Org: Postgres South Africa Call for Papers Open Join the fantastic and growing Postgres community in Cape Town, South Africa for a single day event on October 3rd, 2017. Joshua Drake   #news  Experimenting with Scaling and Full Parallelism in Postgres Postgres has gained a lot of improvements in parallelism for query performance in recent releases. Here’s a look into what it’s able to scale to. Hans-Juergen Schoenig Connecting to Postgres RDS Instances From Kubernetes with SSL Paul Bellamy TimescaleDB vs. Postgres for Time-Series Storage The first in a series of performance benchmarks comparing TimescaleDB to other databases for storing and analyzing time-series data. Rob Kiefer   #opinion  Boost your PostgreSQL database See how SelectStar tracks indexes in your environment to maximize performance. Start your free trial today. SelectStar    #sponsored  cstore_fdw: Columnar Store for Postgres Cstore is the columnar extension for Postgres from Citus. This latest update adds support for Postgres 10 and includes a number of other fixes. pgxn.​org   #tools  Timescale: An Open-Source Time-Series SQL Database Optimized for fast ingest, complex queries, and scalability, Timescale is based around PostgreSQL. Timescale   #tools  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK