checkpoint_segments
От | Mr. Dan |
---|---|
Тема | checkpoint_segments |
Дата | |
Msg-id | BAY102-F9375BE2A35ACC25B23865D1EA0@phx.gbl обсуждение исходный текст |
Ответы |
Re: checkpoint_segments
|
Список | 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
В списке pgsql-admin по дате отправления: