DBA Unfiltered

  • Car engine bay featuring futuristic glowing components and digital displays

    Popping the Hood on Postgres Plan Caching

    Talk Is Cheap In my last post, I talked about how I was amazed that PostgreSQL doesn’t have a shared plan cache like SQL Server does. I wanted to create an experiment / lab where I could see this in action, so I built one. I’m going to be leveraging a free PostgreSQL database hosted…

    Jordan Boich
  • Casino server showing 'NO CACHE' error and smoke while man shows rising profits on tablet

    Cashing In On No Plan Cache

    Something Ain’t Right I’ve been reading the book Introduction to PostgreSQL for the data professional by Ryan Booz and Grant Fritchey. Something they said completely shocked me. “PostgreSQL does not have a query plan cache.” When I read that, as a SQL Server DBA, my eyes genuinely got wide and I had to know more.…

    Jordan Boich
  • Diagram of PostgreSQL database server components including client applications, server processes, shared buffers, disk storage, and administration tools.

    I’m Learning Postgres Before Anyone Makes Me

    What the Heck is Happening? I think we’re seeing more and more DBAs working in environments where there isn’t just one database engine anymore. SQL Server might still be everywhere, but now there’s Postgres, MySQL, cloud-managed databases, and whatever else the application team decided they needed. Companies are either shifting database engines entirely or running…

    Jordan Boich