Dear List,
pgtune suggests the following:
(current value are in braces via reason) , (*) indicates significant difference from current value.
default_statistics_target = 50 # pgtune wizard 2010-06-25 (current 100 via default)
(*) maintenance_work_mem = 1GB # pgtune wizard 2010-06-25 (16MB via default)
checkpoint_completion_target = 0.9 # pgtune wizard 2010-06-25 (0.5 via default)
(*) effective_cache_size = 22GB # pgtune wizard 2010-06-25 (18GB , specified)
work_mem = 192MB # pgtune wizard 2010-06-25 (256MB , specified)
(*) wal_buffers = 8MB # pgtune wizard 2010-06-25 ( 64kb , via default)
checkpoint_segments = 16 # pgtune wizard 2010-06-25 (30 , specified)
shared_buffers = 7680MB # pgtune wizard 2010-06-25 ( 4096 MB , specified)
(*) max_connections = 80 # pgtune wizard 2010-06-25 ( 300 , ;-) specified )
when i reduce max_connections i start getting errors, i will see again concurrent connections
during business hours. lot of our connections are in <IDLE in transaction state> during business
this peculiar behavior of mod_perl servers have been discussed in past i think. dont' remember
if there was any resolution.
