Category Archives: Postgresql

Postgres Performance on AWS EBS

Posted on February 20, 2019 by James Briggs

AWS EBS is network-attached storage … in other words, S L O W, compared to local SSD for Postgres database use. I’ve been seeing average disk latency of 0.55 – 0.80 milliseconds per block (when operating correctly, otherwise 3 ms … Continue reading →

Posted in Linux, Postgresql, Tech | Leave a comment

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