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 225 — September 20, 2017
Is Your Postgres Query Starved for Memory?
Learn how to check if your Postgres query is starved for memory by looking at hash tables inside Postgres, how large a Postgres table can be, and more.
Pat Shaughnessy
Migrating from RethinkDB to Postgres
A great read on migrating from RethinkDB & ElasticSearch to a consolidated Postgres DB.
Phil Freeman
Postgres-BDR: Multi Master Replication Solution
Postgres-BDR, multi-master replication system for geographically distributed clusters, runs as an extension to PostgreSQL 9.6 for 2ndQuadrant 24/7 Support customers. BDR uses highly efficient, asynchronous logical replication for up to 48 nodes.
2ndQuadrant PostgreSQL Products    #sponsored 
Debugging Complex Postgres Queries with pgdebug
An introduction to a tool that can help with debugging incredibly complex queries, an example of which is shown here.
Alex Korban
Tracking and Managing Your Postgres Connections
All connections are not the same to Postgres, some sit idle doing nothing, others are doing work. Here’s a walk through of how to monitor & what to do with various connection types.
Craig Kerstiens
How Can I Return Multiple Rows of Records in PL/pgSQL?
Stack Overflow
PostgreSQL, Explained With Basketball Players
Jon Haines
How Citus Works (with A Look At Dynamic Executors)
Citus is a distributed database that scales out Postgres.
citusdata
Boost your PostgreSQL database
See how SelectStar tracks indexes in your environment to maximize performance. Start your free trial today.
SelectStar    #sponsored 
pspg: An Alternative Pager for psql
Replaces less and brings in support for tabular data.
Pavel Stehule   #tools 
ldap2pg 3.0 Released: Synchronize Roles from LDAP to PG
postgresql.​org   #tools 
BGWorker: Background Worker Processes for Postgres
Written in Go.
pREST   #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.