Don't removes/recycles WAL files at all

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

Responses

Browse pgsql-general by date

  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