checkpoint_segments

From: "Mr(dot) Dan" <bitsandbytes88(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: checkpoint_segments
Date: 2006-03-03 16:31:51
Message-ID: BAY102-F9375BE2A35ACC25B23865D1EA0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

postgresql 8.1.0

Hi,

I have checkpoint_segments set to 18, yet I have 38 segmnet files in
pg_xlog. Is there a reason for that?

Thanks in advance,
~DjK

# WRITE AHEAD LOG
#---------------------------------------------------------------------------

# - Settings -

#fsync = on # turns forced synchronization on or off
#wal_sync_method = fsync # the default is the first option
# supported by the operating system:
# open_datasync
# fdatasync
# fsync
# fsync_writethrough
# open_sync
#full_page_writes = on # recover from partial page writes
#wal_buffers = 8 # min 4, 8KB each
wal_buffers = 16 # min 4, 8KB each
#commit_delay = 0 # range 0-100000, in microseconds
#commit_siblings = 5 # range 1-1000

# - Checkpoints -

#checkpoint_segments = 3 # in logfile segments, min 1, 16MB
each
checkpoint_segments = 18 # in logfile segments, min 1, 16MB
each
#checkpoint_timeout = 300 # range 30-3600, in seconds
#checkpoint_warning = 30 # in seconds, 0 is off

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-03-03 17:17:51 Re: checkpoint_segments
Previous Message Bruce Momjian 2006-03-03 15:11:34 Re: session variable and/or global variable in plpgsql