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