wait events

This tag is associated with 4 posts

Postgres Per-Connection Statistics

Posted by Jeremy ⋅ January 8, 2025 ⋅ Leave a comment

I’ve had a wish list for a few years now of observability-related things I’d love to see someday in community/open-source Postgres. A few items from my wish list: As I’ve noted in a few places, there has been slow and steady progress in Postgres over recent years. There’s also plenty of good discussion continuing on … 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 →

UUID Benchmark War

Posted by Jeremy ⋅ February 3, 2024 ⋅ 4 Comments

This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war. I have decided to orchestrate a benchmark war between four different methods of storing a primary key: The challenge is simple: insert one … Continue reading →

Seattle User Group Thoughts and Fall Opportunities

Posted by Jeremy ⋅ March 7, 2023 ⋅ 1 Comment

Last Thursday was the first in-person Seattle Postgres Users Group meetup since early 2020. We didn’t formally track attendee companies, but I recall having Apple, AWS, Fred Hutch, Google, Microsoft and OtterTune all represented. Besides the presentation about performance, we also had pizza and drinks and a book table. I happily loaned out my copy … Continue reading →