jbc.lol / wafrn
unoffical wafrn mirror wafrn.net
atproto social-network activitypub
fork atom
wafrn / monitoring / database / postgresql.conf
at search-changes 17 lines 439 B view raw
Gabriel Amador García updated db so it has more memory
d55a6374
1max_connections = 400 2shared_buffers = 5GB 3effective_cache_size = 15GB 4maintenance_work_mem = 1280MB 5checkpoint_completion_target = 0.9 6wal_buffers = 16MB 7default_statistics_target = 100 8random_page_cost = 1.1 9effective_io_concurrency = 200 10work_mem = 12725kB 11huge_pages = off 12min_wal_size = 1GB 13max_wal_size = 4GB 14max_worker_processes = 12 15max_parallel_workers_per_gather = 4 16max_parallel_workers = 12 17max_parallel_maintenance_workers = 4