Don't removes/recycles WAL files at all
От | Michael Govorun |
---|---|
Тема | Don't removes/recycles WAL files at all |
Дата | |
Msg-id | m3wudzzyr7.fsf@shpion.ru обсуждение исходный текст |
Ответы |
Re: Don't removes/recycles WAL files at all
(Richard Huxton <dev@archonet.com>)
|
Список | pgsql-general |
Please, help. versions: 7.3.3, 7.3.4 Server don't recycles or removes WAL files at all, generating 12-20 files every day. -rw------- 1 postgres postgres 16777216 Jul 29 01:54 0000000000000000 -rw------- 1 postgres postgres 16777216 Jul 29 01:55 0000000000000001 -rw------- 1 postgres postgres 16777216 Jul 29 02:15 0000000000000002 -rw------- 1 postgres postgres 16777216 Jul 29 06:28 0000000000000003 -rw------- 1 postgres postgres 16777216 Jul 29 09:26 0000000000000004 -rw------- 1 postgres postgres 16777216 Jul 29 11:35 0000000000000005 -rw------- 1 postgres postgres 16777216 Jul 29 13:25 0000000000000006 -rw------- 1 postgres postgres 16777216 Jul 29 15:05 0000000000000007 -rw------- 1 postgres postgres 16777216 Jul 29 16:17 0000000000000008 -rw------- 1 postgres postgres 16777216 Jul 29 17:42 0000000000000009 -rw------- 1 postgres postgres 16777216 Jul 29 19:18 000000000000000A -rw------- 1 postgres postgres 16777216 Jul 29 21:19 000000000000000B -rw------- 1 postgres postgres 16777216 Jul 29 23:11 000000000000000C -rw------- 1 postgres postgres 16777216 Jul 30 01:10 000000000000000D -rw------- 1 postgres postgres 16777216 Jul 30 03:51 000000000000000E -rw------- 1 postgres postgres 16777216 Jul 30 04:00 000000000000000F -rw------- 1 postgres postgres 16777216 Jul 30 04:00 0000000000000010 -rw------- 1 postgres postgres 16777216 Jul 30 06:10 0000000000000011 -rw------- 1 postgres postgres 16777216 Jul 30 08:24 0000000000000012 -rw------- 1 postgres postgres 16777216 Jul 30 09:45 0000000000000013 -rw------- 1 postgres postgres 16777216 Jul 30 11:08 0000000000000014 -rw------- 1 postgres postgres 16777216 Jul 30 12:10 0000000000000015 -rw------- 1 postgres postgres 16777216 Jul 30 13:21 0000000000000016 -rw------- 1 postgres postgres 16777216 Jul 30 14:17 0000000000000017 -rw------- 1 postgres postgres 16777216 Jul 30 15:24 0000000000000018 -rw------- 1 postgres postgres 16777216 Jul 30 16:28 0000000000000019 -rw------- 1 postgres postgres 16777216 Jul 30 17:34 000000000000001A -rw------- 1 postgres postgres 16777216 Jul 30 18:45 000000000000001B -rw------- 1 postgres postgres 16777216 Jul 30 20:00 000000000000001C -rw------- 1 postgres postgres 16777216 Jul 30 21:10 000000000000001D -rw------- 1 postgres postgres 16777216 Jul 30 21:48 000000000000001E I have all settings as defaults in postgresql.conf: #checkpoint_segments = 3 # in logfile segments, min 1, 16MB each #checkpoint_timeout = 300 # range 30-3600, in seconds # #commit_delay = 0 # range 0-100000, in microseconds #commit_siblings = 5 # range 1-1000 # #fsync = true #wal_sync_method = fsync # the default varies across platforms: # # fsync, fdatasync, open_sync, or open_datasync #wal_debug = 0 # range 0-16 -- Michael Govorun
В списке pgsql-general по дате отправления: