From: | Michael Govorun <mike(at)shpion(dot)ru> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Don't removes/recycles WAL files at all |
Date: | 2003-07-30 17:54:20 |
Message-ID: | m3wudzzyr7.fsf@shpion.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Kavan | 2003-07-30 18:03:55 | Re: Postgres Hanging on Inserts |
Previous Message | Vitor Tortorello | 2003-07-30 17:40:30 | plpython and current_timestamp / current_user |