--- title: "Testing the limits of Postgres's connection scalability" publication: "Postgres Weekly" issue: 377 published_at: "2020-10-14" canonical_url: "https://postgresweekly.com/issues/377" --- Plus more news, tutorials, and tips from the Postgres world this week. #377 — October 14, 2020 [Web Version](https://postgresweekly.com/issues/377) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1602675284/fihmm34fouqnzxajl8p2.jpg)](https://www.cybertec-postgresql.com/en/pg_squeeze-optimizing-postgresql-storage/) [Optimizing Storage with `pg_squeeze`](https://www.cybertec-postgresql.com/en/pg_squeeze-optimizing-postgresql-storage/) — A look at an extension that offers periodic, automatic and transparent fixing of tables that exceed a ‘bloat threshold’. _"No more need for `VACUUM FULL` – pg_squeeze has it all."_ Hans-Jürgen Schönig [Analyzing the Limits of Connection Scalability](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/analyzing-the-limits-of-connection-scalability-in-postgres/ba-p/1757266) — Postgres _can_ handle thousands of connections but high numbers of concurrent clients isn’t one of its _strong_ points. This post looks at how things could be improved long-term and where the problems creep in. Andres Freund [![\](https://copm.s3.amazonaws.com/d0de3b33.png)](https://www.crunchydata.com/products/crunchy-bridge/) [Crunchy Bridge: More Postgres Power, Less Administration](https://www.crunchydata.com/products/crunchy-bridge/) — A better option for your Postgres hosting. With a rich set of extensions like PL/Python + SciPy/NumPy/Pandas and more on demand, Crunchy Bridge is made for modern apps. Built by Postgres experts and the team who brought you Heroku Postgres. Crunchy Data sponsor ▶[The State of (Full) Text Search in Postgres 12](https://www.youtube.com/watch?v=6MTOFWQ0efY) — The audio isn’t _great_ but nonetheless this is a great primer to different text search techniques in Postgres starting from the absolute basics (e.g. `LIKE` and `regexp_match`) and moving on to Postgres’s full-fat FTS features. Jimmy Angelakos [On the Community Impact of EDB's 2ndQuadrant Purchase](https://momjian.us/main/blogs/pgblog/2020.html#October_7_2020) — Last week we mentioned that EDB (formerly EnterpriseDB) [acquired 2ndQuadrant](https://www.enterprisedb.com/blog/how-edb-became-leader-postgres-market) – this makes it a bit of a heavyweight in the Postgres space, and Bruce ponders the risks especially as [over half the Postgres core team](https://www.postgresql.org/community/contributors/) (including Bruce) is now from one parent company (this then turned into [a Hacker News discussion.](https://news.ycombinator.com/item?id=24710759)) Bruce Momjian [Making 2 Million Ancient Usenet Posts Available with Postgres and Python](https://www.joe0.com/2020/10/07/converting-utzoo-wiseman-netnews-archive-to-postgresql-using-python-3-8/) — [Usenet](https://en.wikipedia.org/wiki/Usenet) was a fascinating distributed discussion system whose heyday was in the 80s and 90s and there are various archives of posts made to it (such as [someone asking what Postgres is in 1989!](https://usenetarchives.com/view.php?id=comp.databases&g=21592&p=0)). Jozef Jarosciak [Scaling Row Level Security to Group Roles](https://elephanttamer.net/?p=40#rowlevelsecurity) — Row level security lets you grant privileges to selected rows for selected users but what about groups of users or ‘roles’? Enter `pg_has_role`. Elephant Tamer [Postgres Monitoring for Developers: The DBA Fundamentals](https://info.crunchydata.com/blog/postgresql-monitoring-for-application-developers-dba-stats) — A look at several stats you might keep an eye on when managing a Postgres database. [pgmonitor](https://github.com/CrunchyData/pgmonitor) is the sort of tool you can use to track these things. Jonathan S. Katz [Measuring the Memory Overhead of a Postgres Connection](https://blog.anarazel.de/2020/10/07/measuring-the-memory-overhead-of-a-postgres-connection/) — This relates directly to the connection scalability post featured above but may be of separate interest. Andres Freund [Some Query Caching and Load Balancing Tools](https://severalnines.com/database-blog/overview-postgresql-query-caching-load-balancing) — Summarizes some query caching and load balancing options available to use with Postgres, including pgpool-II, Apache Ingest, Heimdall Data, HAProxy, and Bucardo. Viorel Tabara [What Is This Mythical Zero Downtime Database Migration to the Cloud?](https://www.worldforumdisrupt.com/devgraph-webinar-october/) — Join us for a CIO led panel discussion on the issues and risks and the technology available to streamline the experience. ScaleArc sponsor [Multitenancy with Postgres Schemas: Key Concepts Explained](https://blog.arkency.com/multitenancy-with-postgres-schemas-key-concepts-explained/) — If you have an interest in this topic, their [What Surprised Us with Postgres-Schema Multitenancy](https://blog.arkency.com/what-surprised-us-in-postgres-schema-multitenancy/) article may also be of use. Tomasz Wróbel [What's New in `pg_auto_failover` 1.4](https://www.citusdata.com/blog/2020/10/10/whats-new-in-pg-auto-failover/) — `pg_auto_failover` is an open source extension that manages automated failover for Postgres clusters. This release was sent to me with the note: _“In this new 1.4 release Dimitri has added multiple standby support, which is a really big deal.”_ Dimitri Fontaine **Got a new email?** You can [change your address here.](https://postgresweekly.com/edit_subscription/*|UID|*) --- **Bored of us?** [Click here to stop getting Postgres Weekly.](https://postgresweekly.com/leave/*|UID|*) --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- **Want to sponsor?** Email `[kristina@cooperpress.com](mailto:kristina@cooperpress.com)` for details. --- **Want more?** You might like [DB Weekly](https://dbweekly.com/?utm_source=pg&utm_medium=email&utm_campaign=footer-promo), our more general database newsletter covering data storage trends, new database types, and more. --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)