[GENERAL] Don't removes/recycles WAL files at all

[Michael Govorun]

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 
-rw---1 postgres postgres 16777216 Jul 29 01:55 0001
-rw---1 postgres postgres 16777216 Jul 29 02:15 0002
-rw---1 postgres postgres 16777216 Jul 29 06:28 0003
-rw---1 postgres postgres 16777216 Jul 29 09:26 0004
-rw---1 postgres postgres 16777216 Jul 29 11:35 0005
-rw---1 postgres postgres 16777216 Jul 29 13:25 0006
-rw---1 postgres postgres 16777216 Jul 29 15:05 0007
-rw---1 postgres postgres 16777216 Jul 29 16:17 0008
-rw---1 postgres postgres 16777216 Jul 29 17:42 0009
-rw---1 postgres postgres 16777216 Jul 29 19:18 000A
-rw---1 postgres postgres 16777216 Jul 29 21:19 000B
-rw---1 postgres postgres 16777216 Jul 29 23:11 000C
-rw---1 postgres postgres 16777216 Jul 30 01:10 000D
-rw---1 postgres postgres 16777216 Jul 30 03:51 000E
-rw---1 postgres postgres 16777216 Jul 30 04:00 000F
-rw---1 postgres postgres 16777216 Jul 30 04:00 0010
-rw---1 postgres postgres 16777216 Jul 30 06:10 0011
-rw---1 postgres postgres 16777216 Jul 30 08:24 0012
-rw---1 postgres postgres 16777216 Jul 30 09:45 0013
-rw---1 postgres postgres 16777216 Jul 30 11:08 0014
-rw---1 postgres postgres 16777216 Jul 30 12:10 0015
-rw---1 postgres postgres 16777216 Jul 30 13:21 0016
-rw---1 postgres postgres 16777216 Jul 30 14:17 0017
-rw---1 postgres postgres 16777216 Jul 30 15:24 0018
-rw---1 postgres postgres 16777216 Jul 30 16:28 0019
-rw---1 postgres postgres 16777216 Jul 30 17:34 001A
-rw---1 postgres postgres 16777216 Jul 30 18:45 001B
-rw---1 postgres postgres 16777216 Jul 30 20:00 001C
-rw---1 postgres postgres 16777216 Jul 30 21:10 001D
-rw---1 postgres postgres 16777216 Jul 30 21:48 001E



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-10, 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

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [GENERAL] Don't removes/recycles WAL files at all

[Michael Govorun]

Tom Lane <[EMAIL PROTECTED]> writes:

> Yeah, adding or removing -malign-double would change the layout of our
> on-disk data structures, so it's no surprise you'd need to dump and
> reload for that.
>
> Also, -ffast-math is known to be Evil.  I thought we had a check to
> prevent that (looks ...) yeah we do; how'd you get by this check in
> timestamp.c?
>
> /*
>  * gcc's -ffast-math switch breaks routines that expect exact results from
>  * expressions like timeval / 3600, where timeval is double.
>  */
> #ifdef __FAST_MATH__
> #error -ffast-math is known to break this code
> #endif

Thanks for info, but I did not see this error.

> As for the other stuff, it theoretically should work, but isn't
>egcs-2.91.66 rather old and buggy?  Perhaps a newer gcc would work
>better.

Yes, it's old redhat 6.2 and whole system for a long time needs
upgrade.

-- 
Michael Govorun

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster