If you need to speed up text searches, and you’re willing to make database schema changes and query changes, then Alex Klibisz explains how to use trigrams. If you’re considering…
If you use Roman numerals like MMXXV, you’ll be thrilled to know that Postgres 18 is adding more support for it as Hubert Lubaczewski explains. Also, I have questions about…
If you want faster reports, Karen Jex gives a good high-level overview of Postgres settings to review. This isn’t about giving you exact setting values, but more about a list…
If you want advice on common performance scale issues, Shayon Mukherjee’s list of problems & solutions is beautifully concise. Seriously, it’s good and straight to the point. If you need…
Idle transactions cause table bloat, as Umair Shahid explains, because Postgres has to leave dead tuples in place. At first this looks like a ChatGPT-generated post, but hang in there,…
If you wanna learn about Postgres data types, the first several modules of Aaron Francis’ Mastering Postgres class are free. While you’re at it, PGconf.eu’s videos from October are up…
If you want to learn database concepts in free YouTube videos that sound like you’re listening to a casual friend chat over drinks, check out Hussein Nasser’s database engineering playlist.…
Struggling with vacuuming? Got a table where you’re constantly deleting the oldest data, and vacuuming can’t keep up? It’s time to investigate partitioning with Lee Asher. Want a production PostgreSQL…
Looking for a Postgres job? Hairetsu put together hiring.fm, which scrapes jobs from over 10,000 company sites (not recruiter spam.) Just put “Postgres” in the search box, pick your country…
If things get really bad, and VACUUM can’t keep up with the level of changes happening in your database, Andreas Scherbaum explains how old versions of data might suddenly become…