Postgres Pro
Downloads
Home   >   mailing lists

Re: Server writing short WAL files - Mailing list pgsql-general

From Tom Lane
Subject Re: Server writing short WAL files
Date
Msg-id 29860.1341525602@sss.pgh.pa.us
Whole thread Raw
In response to Server writing short WAL files  (beamsplitter@gmail.com)
List pgsql-general
Tree view 
beamsplitter@gmail.com writes:
> I'm having trouble with WAL files. Every 4th WAL file written by the server
> into pg_xlog is 24576 bytes instead of 16MB. A short WAL causes a fatal
> error during recovery.

Hm.  It's fairly hard to see how you could get into such a state to
start with, but once there was a short WAL file present in pg_xlog,
the server might keep on recycling it for re-use.  Try physically
deleting or padding out the short file.

            regards, tom lane

pgsql-general by date:

Previous
From: Steven Schlansker
Date:
Subject: Suboptimal query plan fixed by replacing OR with UNION
Next
From: Tom Lane
Date:
Subject: Re: Suboptimal query plan fixed by replacing OR with UNION