Samples of b-tree, GIN, and GIST indexes for Postgres beginners.
Highlights from the 3rd annual PostGIS Day, hosted virtually November 18th, 2021.
The ultimate goal for any unplanned database interruption is to reduce data loss. So the advice here is aimed at someone in a production situation prioritizing minimizing data loss.
What follows is a summary of conversations I've had with customers on how to think about key tenants of database management, high availability and disaster recovery.