TOPIC / TAG
Notes in postgresql
3 articles
A Small Backup Restore Drill
Find out whether a PostgreSQL backup really restores by loading it into a throwaway database and checking the result.
Use EXPLAIN ANALYZE Without Surprises
Read a real PostgreSQL query plan while limiting runtime risk and remembering that ANALYZE executes the statement.
PostgreSQL Memory Settings on a Small VPS
Check and size sharedbuffers, effectivecachesize, workmem, maintenanceworkmem, and maxconnections on a small server, apply them with the right reload or restart, and confirm the effect.