PostgreSQL Tuning
See https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Referenced from https://matrix-org.github.io/synapse/latest/postgres.html#tuning-postgres
we've found tuning the following values helpful for performance:
shared_buffers
effective_cache_size
work_mem
maintenance_work_mem
autovacuum_work_mem
Note that the appropriate values for those fields depend on the amount of free memory the database host has available.
Edited by Chris Croome