Category Archives: Postgresql

Postgres Monitoring Script pg_glance.sh Available

Posted on February 5, 2019 by James Briggs

I wrote a small performance monitoring script for Postgres during the Super Bowl on Sunday called pg_glance. You can download it from my github project pg_glance. Getting Started with pg_glance It’s easy to get started … If you’re remotely monitoring … Continue reading →

Posted in Postgresql, Tech | Leave a comment

Facebook Production Engineering Open House 2018

Posted on May 31, 2018 by James Briggs

I attended the Facebook Production Engineering Open House at their Menlo Park HQ. “Production Engineering is Facebook’s secret sauce – it draws on multiple disciplines (Software Engineering, Systems Administration, Distributed Systems and Networking) to plan, build and maintain the massive … Continue reading →

Posted in API Programming, Cloud, Linux, Microservices, Postgresql, Tech | Leave a comment

PostgreSQL and “PANIC: replication checkpoint has wrong magic” error

Posted on May 19, 2018 by James Briggs

PSA: I haven’t seen a solution to this issue online, so posting it here for search engines to index. PostgreSQL is an ACID-compliant database, but filesystem corruption can still prevent it from starting. In my case, a linux test instance … Continue reading →

Posted in Open Source, Postgresql, Tech | Leave a comment

Percona Live 2018 Conference

Posted on April 28, 2018 by James Briggs

I attended the Percona Live 2018 database conference in Santa Clara again. As always, the conference was very well-organized and had great talks. For 2018, Percona attempted to make it more affordable, with prices in the $600 range. Much appreciated! … Continue reading →

Posted in API Programming, Linux, MySQL, Open Source, Oracle, Postgresql, Tech | Leave a comment

Postgresql vs MySQL in the Enterprise

Posted on March 30, 2018 by James Briggs

There are few people who have used both MySQL and Postgresql in production at scale. Both are great Open Source databases, so I thought I’d add some comments based on my experience. Feature MySQL/InnoDB Postgresql Replication Many options, simple to … Continue reading →

Posted in MySQL, MySQL Cluster, Open Source, Postgresql, Tech | Leave a comment