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.
Migrating from RethinkDB to Postgres
A great read on migrating from RethinkDB & ElasticSearch to a consolidated Postgres DB.
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
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.
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.
How Can I Return Multiple Rows of Records in PL/pgSQL?
PostgreSQL, Explained With Basketball Players
How Citus Works (with A Look At Dynamic Executors)
Citus is a distributed database that scales out Postgres.
Boost your PostgreSQL database
See how SelectStar tracks indexes in your environment to maximize performance. Start your free trial today.
pspg: An Alternative Pager for psql
and brings in support for tabular data.
ldap2pg 3.0 Released: Synchronize Roles from LDAP to PG
BGWorker: Background Worker Processes for Postgres
Written in Go.