Re: Background writer configuration

>>> On Thu, Mar 16, 2006 at 12:15 pm, in message
<20060316211523(dot)73343cee(dot)eugrid(at)fpm(dot)kubsu(dot)ru>, Evgeny Gridasov
<eugrid(at)fpm(dot)kubsu(dot)ru> wrote:
>
> please, could you post other settings from your postgresql.conf?

Everything in postgresql.conf which is not commented out:

listen_addresses = '*' # what IP interface(s) to listen on;
max_connections = 600 # note: increasing
max_connections costs
shared_buffers = 20000 # min 16 or max_connections*2,
8KB each
work_mem = 10240 # min 64, size in KB
max_fsm_pages = 1400000 # min max_fsm_relations*16, 6
bytes each
bgwriter_lru_percent = 20.0 # 0-100% of LRU buffers
scanned/round
bgwriter_lru_maxpages = 200 # 0-1000 buffers max
written/round
bgwriter_all_percent = 10.0 # 0-100% of all buffers
scanned/round
bgwriter_all_maxpages = 600 # 0-1000 buffers max
written/round
full_page_writes = off # recover from partial page
writes
wal_buffers = 20 # min 4, 8KB each
checkpoint_segments = 10 # in logfile segments, min 1,
16MB each
effective_cache_size = 524288 # typically 8KB each
random_page_cost = 2 # units are one sequential page
fetch
redirect_stderr = on # Enable capturing of stderr
into log
log_line_prefix = '[%m] %p %q<%u %d %r> ' #
Special values:
stats_start_collector = on
stats_block_level = on
stats_row_level = on
autovacuum = true # enable autovacuum
subprocess?
autovacuum_naptime = 10 # time between autovacuum runs, in
secs
autovacuum_vacuum_threshold = 1 # min # of tuple updates before
autovacuum_analyze_threshold = 1 # min # of tuple updates
before
autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before
autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before
lc_messages = 'C' # locale for system error
message
lc_monetary = 'C' # locale for monetary
formatting
lc_numeric = 'C' # locale for number formatting
lc_time = 'C' # locale for time formatting
sql_inheritance = off
standard_conforming_strings = on