---
title: "#225: Tracking and Managing Your Postgres Connections"
publication: "Postgres Weekly"
issue: 225
published_at: "2017-09-20"
canonical_url: "https://postgresweekly.com/issues/225"
---

Postgres Weekly 225   . 

[Read this on the Web](http://postgresweekly.com/issues/225) 

[Postgres Weekly](http://postgresweekly.com) Issue 225 — September 20, 2017     

[Is Your Postgres Query Starved for Memory?](https://dzone.com/articles/is-your-postgres-query-starved-for-memory?utm_source=postgresweekly&utm_medium=email)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](https://medium.com/fuzzy-sharp/migrating-to-postgres-2dc1519a6dc7?utm_source=postgresweekly&utm_medium=email)A great read on migrating from RethinkDB & ElasticSearch to a consolidated Postgres DB. Phil Freeman [Postgres-BDR: Multi Master Replication Solution](https://2ndquadrant.com/en/resources/bdr/)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[![\](https://copm.s3.amazonaws.com/0a261aa3.jpg)](https://2ndquadrant.com/en/resources/bdr/) [Debugging Complex Postgres Queries with pgdebug](http://korban.net/posts/postgres/2017-09-18-debugging-complex-postgres-queries-with-pgdebug/?utm_source=postgresweekly&utm_medium=email)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](http://www.craigkerstiens.com/2017/09/18/postgres-connection-management/?utm_source=postgresweekly&utm_medium=email)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?](https://dba.stackexchange.com/questions/186257/how-can-i-return-multiple-rows-of-records-in-pl-pgsql?utm_source=postgresweekly&utm_medium=email) Stack Overflow [PostgreSQL, Explained With Basketball Players](https://hackernoon.com/postgresql-explained-with-basketball-players-f99fb812c065?utm_source=postgresweekly&utm_medium=email) Jon Haines [How Citus Works (with A Look At Dynamic Executors)](https://www.citusdata.com/blog/2017/09/15/how-citus-works/?utm_source=postgresweekly&utm_medium=email)Citus is a distributed database that scales out Postgres. citusdata [Boost your PostgreSQL database](https://selectstar.io/blog/postgresql-performance-indexes/?utm_source=sponsored&utm_medium=email&utm_campaign=9+20+2017+Postgres+Weekly)See how SelectStar tracks indexes in your environment to maximize performance. Start your free trial today. SelectStar#sponsored [pspg: An Alternative Pager for psql](https://github.com/okbob/pspg?utm_source=postgresweekly&utm_medium=email)Replaces `less` and brings in support for tabular data. Pavel Stehule#tools [ldap2pg 3.0 Released: Synchronize Roles from LDAP to PG](https://www.postgresql.org/about/news/1781/?utm_source=postgresweekly&utm_medium=email) postgresql.​org#tools [BGWorker: Background Worker Processes for Postgres](https://github.com/prest/bgworker?utm_source=postgresweekly&utm_medium=email)Written in Go. pREST#code    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/225) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK