-
Optimize PostgreSQL Server Performance Through Configuration
Optimize PostgreSQL Server Performance Through Configuration
Postgres is great and it has so many options to tune its performance. New article pop up time to time.
There are four high-level settings which will be discussed here: sharedbuffers, walbuffers, effectivecachesize, and maintenanceworkmem.