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.
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.
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.