-- postgresql.conf production tweaks max_connections = 200 shared_buffers = 25% of RAM effective_cache_size = 75% of RAM work_mem = 4MB -- per operation maintenance_work_mem = 64MB wal_buffers = 16MB max_wal_senders = 5
Moving to Production: A Comprehensive Guide to Production-Settings for Modern Applications production-settings