#​443 — February 23, 2022

Web Version

Postgres Weekly

⭐️  Optimizing Postgres Text Search with Trigrams — A particularly thorough tutorial on using Postgres’s core pg_trgm module for both precise and fuzzy textual searching (as opposed to FTS). So much depth here I think few would fail to learn something useful – I didn’t know you could customize the precision of GiST indexes, for example. I hope Alex writes more in future!

Alex Klibisz

🐘 The Developer Experience You Always Wanted for Postgres — Database as a service for Postgres as it should be. Cloud agnostic, superuser access, performance tuned instances, and packed with all the extensions you need. From the Crunchy Data team that’s 100% focused on Postgres at any scale. Try it today.

Crunchy Bridge sponsor

The Queries in PostgreSQL Series: Query Execution Stages — Well known for their extensive articles on Postgres index types (like this one on Btree), Egor is back with a new series digging into the execution of queries. Lots to learn here.

Egor Rogov

Timescale Raises $110M in Series C Funding RoundTimescaleDB is an open source (but backed by a company offering commercial services) time series oriented extension for Postgres that has become popular in recent years. The company behind it (and, disclosure, occasional sponsor of this newsletter) has announced a major fundraising round and shares some of its plans here, including contributions to the Postgres project overall, so hopefully the entire ecosystem wins.

Timescale Blog

Monitoring Google Cloud PostgreSQL with pgwatch2pgwatch2 is a Postgres monitoring tool and while it can be tricky to make external tools work against managed cloud services, it’s totally possible here.

Kaarel Moppel

eBook: Best-Practices for Speeding Up Postgres Queries

pganalyze sponsor

Table Size in YugabyteDB, PostgreSQL and OracleYugabyteDB is one of those (many) databases that isn’t Postgres but speaks the language. Since it takes a different approach in various areas, the amount of disk space it uses for equivalent data can be different too, and Franck shows by just how much in this test.

Franck Pachot

pg-osc: Zero Downtime Schema Changes in Postgres — pg-osc is a tool (written in Ruby) for making non-blocking, zero downtime schema changes by way of ‘shadow tables.’ This post provides a quick introduction. GitHub repo.

Shayon Mukherjee

In brief: