Re: Background writer configuration - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Background writer configuration
Date
Msg-id 44198B3D.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Background writer configuration  (Evgeny Gridasov <eugrid@fpm.kubsu.ru>)
Responses Re: Background writer configuration  (Evgeny Gridasov <eugrid@fpm.kubsu.ru>)
List pgsql-performance
>>> On Thu, Mar 16, 2006 at 12:15 pm, in message
<20060316211523.73343cee.eugrid@fpm.kubsu.ru>, Evgeny Gridasov
<eugrid@fpm.kubsu.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


pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: Re: Help optimizing a slow index scan
Next
From: "Luke Lonergan"
Date:
Subject: Re: 1 TB of memory