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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Minimal system (was Re: Basic questions before start)
Следующее
От: "Adam Kavan"
Дата:
Сообщение: Re: Postgres Hanging on Inserts