Archive for

Major Developments in Postgres Extension Discovery and Distribution

Posted by Jeremy ⋅ March 21, 2024 ⋅ Leave a comment

PostgreSQL “extensions” are a big part of what makes this database special. The developers building the core Postgres database are amazing. But many people don’t realize just how much of a “data platform” Postgres is (borrowing this phrase from something Craig Kerstiens recently posted online) and just how decentralized the development is for PostgreSQL’s capabilities. … Continue reading →

Postgres Indexes, Partitioning and LWLock:LockManager Scalability

Posted by Jeremy ⋅ March 3, 2024 ⋅ 4 Comments

I have decided that – in Postgres circles – I shall henceforth refer to 2023 as THE YEAR OF THE LOCK MANAGER’S REVENGE. Let me explain. Lets start with Bruce Momjian. He has an in-depth presentation about locking in general with PostgreSQL called “Unlocking the Postgres Lock Manager“. I see online that he’s been giving … Continue reading →