#377 — October 14, 2020

Web Version

Postgres Weekly

Optimizing Storage with pg_squeeze — 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 — 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

Crunchy Bridge: More Postgres Power, Less Administration — 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 — 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 — Last week we mentioned that EDB (formerly EnterpriseDB) acquired 2ndQuadrant – 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 (including Bruce) is now from one parent company (this then turned into a Hacker News discussion.)

Bruce Momjian

Making 2 Million Ancient Usenet Posts Available with Postgres and PythonUsenet 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!).

Jozef Jarosciak

Scaling Row Level Security to Group Roles — 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 — A look at several stats you might keep an eye on when managing a Postgres database. pgmonitor is the sort of tool you can use to track these things.

Jonathan S. Katz

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 — 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? — 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 — If you have an interest in this topic, their What Surprised Us with Postgres-Schema Multitenancy article may also be of use.

Tomasz Wróbel

What's New in pg_auto_failover 1.4pg_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