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 224 — September 13, 2017
Better Database Migrations in Postgres
Database migrations are a regular activity for any app, but there are a few things that can help make them run smoother on a production app. Here are a couple of tips to help manage migrations better.
Craig Kerstiens
Postgres's Workings in One Picture
An interesting ‘infographic’ style image showing the various components of Postgres and how they stack together.
Alexey Lesovsky
Postgres Load Testing with pgreplay
If you’re looking to simulate a production workload against a database once you make some changes, pgreplay can help. It parses Postgres logs and then replays them for you.
Eric Worden
JackDB: A modern database client for Postgres
JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today.
JackDB, Inc.​    #sponsored 
Citus 7: Transactions, Framework Integration, and Postgres 10
Citus 7, which extends Postgres to easily shard your database, is here and introduces a number of new features including a foundation for distributed transactions, better framework integration, and Postgres 10 support.
citusdata
Using Atomic Transactions to Power an Idempotent API
The start of a series of posts on building more robust (and data accurate) APIs by leaning on Postgres’s transactional features.
Brandur Leach
Speeding Up Creation of Postgres Replicas
What can be done when the PostgreSQL replication process is painfully slow for bigger databases? Here are some tricks to make things easier.
Kaarel Moppel
Partitioning in Postgres 10 and Beyond
Postgres 10 is coming with some native table partitioning. While this was possible before it took more manual work. Here's a few links with an early look at what’s coming.
Bruce Momjian
A Brief Reminder About Casting TIMESTAMPTZ
‘Timestamp with timezone’ is an awesome datatype but you need to take care to be explicit on your timezone lest you be stumped on data seeming off.
Cristophe Pettus
An Interview with Microsoft on Adding Postgres to Azure
Microsoft’s Rohan Kumar on how they approach Postgres and the wider community.
PostgresOpen SV 2017
PostgreSQL Automatic Failover 2.2 Released
An agent for the Pacemaker high availability cluster resource manager to let it keep tabs on Postgres instances.
Mael Rimbault and Jehan-Guillaume de Rorthais   #tools 
pglite: A Tiny (Shell) Script to Manage Ephemeral Postgres Databases
Jason Dusek   #tools 
Say hello to PostgreSQL’s perfect match
Start a free trial to see how SelectStar’s comprehensive monitoring can compliment your Postgres environment.
SelectStar    #sponsored 
hkpg: Automated Archiving of Heroku Postgres Backups to S3
Simon Taranto   #code 
pqstream: Turn Your Postgres Database Into an Event Stream
This could be used to get going with event sourcing without having to install any new software.
Travis Cline   #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.