Announcing Early Access to My Performance Training
I’ve been working with Microsoft SQL Server for about 25 years, but in 2017, I began working with PostgreSQL. I never thought I’d learn Postgres well enough to teach it,…
Smart Postgres News and Techniques 2024 Vol 12
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…
Download the Stack Overflow Sample Database for Postgres
For my Query Exercises, I like using the Stack Overflow data dump because it’s interesting data, real-world-sized, and has real-world-challenges with data distribution and slow queries. It’s easy to understand…
Smart Postgres News and Techniques 2024 Vol 11
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…
Smart Postgres News and Techniques 2024 Vol 10
If your COMMIT is slow, Laurenz Albe gives you a few places to start troubleshooting, including deferred constraints and sync replication. Writing Postgres code is hard. Robert Haas’s post isn’t…
PGconf.dev Vancouver 2024: Day 3 Notes
The last day of PGconf.dev 2024 Vancouver was an unconference. I’d never attended one of these before, so I was really curious to see how it would go. Like I…
PGconf.dev Vancouver 2024: Day 2 Notes
I’m in Vancouver this week for PGconf.dev 2024. Yesterday I blogged my notes from Day 1, and continuing on, here are the sessions I attended on Thursday: PostgreSQL 17 and…
PGConf.dev Vancouver 2024: Day 1 Notes
I’m in Vancouver this week at PGConf.dev, a conference is aimed at people who are either hacking on Postgres source code, or building extensions, or growing the community. I don’t…
Smart Postgres News and Techniques 2024 Vol 9
Microsoft’s extending Postgres with AI. At this week’s Microsoft Build conference, they announced general availability for the azure_ai extension in Azure Database for PostgreSQL. (I really wish they’d simplify the…
Smart Postgres News and Techniques 2024 Vol 8
If you write queries – and forgive me, because I know that sounds like everyone, and that’s because it is – then you need to know how Postgres handles nulls.…