Archive for

Researching the Performance Puzzle

Posted by Jeremy ⋅ July 31, 2022 ⋅ 1 Comment

The PostgreSQL Performance Puzzle was, perhaps, too easy – it didn’t take long for someone to guess the correct answer! But I didn’t see much discussion about why the difference or what was happening. My emphasis on the magnitude of the difference was a tip-off that there’s much more than meets the eye with this … Continue reading →

PostgreSQL Performance Puzzle

Posted by Jeremy ⋅ July 16, 2022 ⋅ 15 Comments

Update 7/18: y’all guessed the answer to my puzzle very fast! At the bottom of this blog post, I’ve added the expressions that I used (with credit to those who guessed it), and also other expressions guessed by readers which exhibited similar behavior. I’ll do another follow-up blog post touching on several layers of this … Continue reading →

A Hairy PostgreSQL Incident

Posted by Jeremy ⋅ February 10, 2022 ⋅ 24 Comments

It was 5:17pm today, just as I was wrapping up work for the day, and my manager pinged me with the following chat: <manager>: Hi Jeremy – we have a <other team> ticket – escalated to <leader>, <leader>, etc. <principal> is on trying to advise as well. Are you available this evening if needed for … Continue reading →