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

From: Michael Govorun <mike(at)shpion(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Don't removes/recycles WAL files at all
Date: 2003-07-31 02:54:24
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

>>> Server don't recycles or removes WAL files at all, generating 12-20
>>> files every day.
> There's something broken there. Check to see why checkpoint operations
> are not completing (look in the postmaster log for relevant error
> messages). Open transactions should not affect this.

I've found answer! Postgresql have been compiled with aggressive
gcc version egcs-2.91.66
CFLAGS='-O9 -funroll-loops -ffast-math -malign-double -mcpu=pentiumpro
-march=pentiumpro -fomit-frame-pointer -fno-exceptions'

After recompiling server with -O2 WAL recycling properly. But I got
many errors after installing recompiled server and had to dump
database with "optimized" postgres and restore with -O2 version.

Michael Govorun

In response to


Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-31 03:05:38 Re: Postgres Hanging on Inserts
Previous Message Joe Conway 2003-07-31 00:02:47 Re: hexadecimal to decimal