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_bufferseffective_cache_sizework_memmaintenance_work_memautovacuum_work_memNote that the appropriate values for those fields depend on the amount of free memory the database host has available.
Edited by Chris Croome