Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 226 — September 27, 2017
PostgreSQL's Hash Indexes Are Now Cool
Before Postgres 10, hash indexes were severely flawed but things are turning around fast as Robert explains here.
Robert Haas
PostgreSQL 10 RC1 Released
The first release candidate of version 10 is now available for download.
PostgreSQL.​org   #news 
pglogical 2.0 - The next generation of logical replication from 2ndQuadrant
pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. Replicate your data with this alternative to physical replication & achieve zero-downtime.
2ndQuadrant PostgreSQL Products    #sponsored 
'The Day I Reached The 1600 Columns Limit in Postgres'
Postgres doesn’t reclaim space when dropping a column which can be a problem in situations where you create and remove many temporary columns.. An interesting story.
Rodrigo Rosenfeld Rosas
What's New in Postgres 10
A laundry list of changes in the forthcoming new major version of Postgres.
PostgreSQL Wiki   #news 
Unit Testing Postgres with the pgTAP Framework
Simon McClive
Migrating From Single-Node Postgres to Citus
Some steps to follow for migration to Citus.
Craig Kerstiens
Multi-Dimensional Choropleth Maps using PostGIS, GeoServer, and Google Earth
Mark Mathis
Taming Postgres Autovacuum
When tuning autovacuum, ‘start with the default settings and check table bloat regularly’.
Torsten Bøgh Köster
Transactionally Staged Job Drains in Postgres
Building a robust background worker system that leverages transactional isolation to never work a job too early, and transactional durability to never let one drop.
Brandur Leach
Bridging the PostgreSQL Chasm
“What I see lacking as a whole with PostgreSQL is effective communication and outreach to engage and onboard new users and developers.”
Debbie Cerda   #opinion 
Dive deeper into your Postgres database with SelectStar
Start a free trial and see how advanced queries help optimize performance.
SelectStar    #sponsored 
Podyn: DynamoDB to Postgres Replication and Migration Tool
Marco Slot   #tools 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.