Postgres Pro
Downloads
Home   >   mailing lists

WAL file lifespan (7.1RC1) - Mailing list pgsql-general

From Brian Baquiran
Subject WAL file lifespan (7.1RC1)
Date
Msg-id 066b01c0b663$be9fdfe0$4e64a8c0@edsamail.com
Whole thread Raw
Responses Re: WAL file lifespan (7.1RC1)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
How long should I expect WAL files in $PGDATA/pg_xlog to hang around?

Last night I loaded up around 8GB of data and in the morning I there were
118 files in $PGDATA/pg_xlog. They didn't go away until after I shutdown and
restarted the database and I saw a bunch of "DEBUG:  MoveOfflineLogs: remove
0000000200000008"  in my logfiles.

Brian

pgsql-general by date:

Previous
From: Alvar Freude
Date:
Subject: Inserting possible dublicate unique keys
Next
From: "Jeff"
Date:
Subject: How to auto create a unique key for each newly added record?