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
  • 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