wait events

This tag is associated with 3 posts

Postgres Indexes, Partitioning and LWLock:LockManager Scalability

Posted by Jeremy ⋅ March 3, 2024 ⋅ 3 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 ⋅ 3 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 →