Category Archives: Postgresql

Postgres Performance on AWS EBS

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

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

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

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

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