How have the fixes for the recent Spectre and Meltdown CPU vulnerabilities affected Postgres performance? This first look suggests about a 7% performance hit.
No tuning equals below par performance. But which parameters to tune? This talk looks at the performance advantages of appropriately tuning your postgresql.conf file.
Indexes are pretty easy to add and should speed up query performance, except sometimes it's more complicated. This deep dive is a great look at analyzing query and index perf.
“When running backfills or any long job it’s crucial to be conscious of how long any particular transaction will be running, and do a better of chunking the work into separate queries if possible.”
