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 151 — April 6, 2016
PostgreSQL: 2016-03-31 Security Update Release
Point releases are here for all the latest versions of Postgres. While the security issues here could be a lot worse, it’s still encouraged to upgrade when you’re able to.
postgresql.​org
Postgres 9.6 Feature Highlight: Read Balancing with remote_apply
Postgres 9.6 features are mostly set at this point, but this is a new one that just made it in. A new level of synchronous commit, ‘remote_apply’, will make easier some guarantees on the read consistent side when used.
Michael Paquier   #news 
Five Ways to Paginate in Postgres, From The Basic to The Exotic
This article examines several methods of server-side pagination and discusses their tradeoffs when implemented in PostgreSQL.
Joe Nelson   #tutorial 
PostgreSQL and per-connection write consistency settings
When it comes to consistent performance, PostgreSQL has some good, predictable defaults. But there are tradeoffs between performance, consistency and outages. In this article we examine the tradeoffs and discuss per-connection tunable write consistency over a cluster.
Compose    #sponsored 
ETL Journey from Oracle to Postgres
We’ve covered a number of articles about migrating from MySQL or MongoDB to Postgres. Here’s one we haven’t seen as much of - moving from Oracle to Postgres.
Pivotal Engineering Journal
PostgreSQL Conference US is in 2 Weeks
Join the rest of the community at one of its biggest conferences in NYC - April 18-20.
PGConf US   #news 
Parallel Sequential Scan Support in Postgres
A commit to the Postgres codebase that “extends synchronous replication so that it supports multiple synchronous standby servers.”
postgresql.​org   #news 
A Tour of PostgREST
PostgREST is a tool for giving you a good, clean and powerful Postgres-driven API out of the box. This video walks you through its functionality and features.
Joe Nelson   #video 
PostgreSQL Bloat: Origins, Monitoring and Managing
A look at the wider aspects of monitoring and managing the ‘bloat’ in PostgreSQL that’s a consequence of its MVCC model.
Robert M.​ Wysocki   #opinion 
Event: An Introduction to PostgreSQL (London, April 13)
A free seminar taking place in London, led by Simon Riggs.
2ndQuadrant   #news 
pg_tmp: Run Tests On An Isolated, Temporary Postgres Database
Eric Radman   #tools 
pg_recall: An Extension That Tracks Changes to Tables
Keeps track of changes in a separate _log table (one _log table for each managed data table).
Manuel Reithuber   #tools 
Monitoring Wait Events in PostgreSQL 9.6
A look at pg_wait_sampling which automates gathering sampling statistics of wait events.
Alexander Korotkov   #tools 
PostgreSQL Health Check - Get Your Database Checked By Our Experts
A comprehensive audit of your database architecture to improve performance, uptime, security and recoverability.
2ndQuadrant    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.