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 176 — September 29, 2016

Don't adjust your sets - Postgres Weekly is out a day later than usual because the noteworthy 9.6 release was due today :-)

Postgres 9.6 Released
The next key release of Postgres is here and ready to roll. Key features include parallel queries, faster autovacuum, phrase searching in full-text search, and many performance improvements. Release notes here.
postgresql.​org
The Major Features in Postgres 9.6 [PDF]
Straightforward, simple slides with the basics on 9.6’s new features.
Bruce Momjian
pg_healer: Repair Postgres Problems Automatically
Corruption is inevitable, and given a long enough timespan it can occur on many databases. pg_healer is a new extension that monitors for corruption and helps repair it.
Greg Sabino Mullane   #tools 
A lightning-fast server for a powerful database.
Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code 'POSTGRES20'.
Linode    #sponsored 
Announcing Citus MX: Scaling Postgres to Over 500k Writes Per Second
The private beta of Citus MX is now available.
Citus Data   #news 
PostgreSQL Replication Checklist
Postgres replication is a staple of any production installation, but there’s a number of options. This great guide from OpenSCG lays out the options and things you should think through as you decide which to use.
David Rader
PGLiveBackup Beta 1: A bash-Based Postgres Backup and Restore Tool
postgresql.​org   #tools 
PostGIS 2.3.0 Released
PostGIS 2.3 is already here with support for Postgres 9.6. The best part is it already leverages possibly the best feature in 9.6: parallelism. If you’re using PostGIS consider giving it a try.
PostGIS Developers   #tools 
Barman 2.0 Released: A Backup Manager for Postgres
An open-source administration tool for disaster recovery of PostgreSQL servers.
Gabriele Bartolini   #tools 
pg-eyeballs: Use Postgres' 'EXPLAIN' Command from ActiveRecord
Brad Urani   #code 
asyncpg: A Fast PostgreSQL Database Client Library for Python/asyncio
magicstack   #code 
Publish Web Apps Based On Your PostgreSQL Database Fast
Envelope is designed to completely replace the middleware that sits between your web server and your PostgreSQL database.
Workflow Products   #code 
Stop wasting time - know what you'll earn before the interview
On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week.
Hired.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.