Re: Background writer configuration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>> On Thu, Mar 16, 2006 at 12:15 pm, in message
<20060316211523.73343cee.eugrid@xxxxxxxxxxxx>, Evgeny Gridasov
<eugrid@xxxxxxxxxxxx> 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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux