> Am I correct that with no UNDO in 7.1.X, we should only be keeping one
> WAL file around, or maybe two?
Not necessarily. How much do you do between checkpoints?
But yeah, there's no reason to save data further back than one or maybe
two checkpoints, as long as UNDO isn't there.
Steve Wampler <[EMAIL PROTECTED]> writes:
> Are the WAL segment files the ones located in pg_xlog?
Right, the ones with sixteen-hex-digit filenames. Sorry for not being
perfectly clear.
regards, tom lane
---(end of broadcast)-
Steve Wampler <[EMAIL PROTECTED]> writes:
> FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.16747) failed: No such file
>or directory
The error message is bogus --- almost certainly, the real problem is not
enough free space to create another 16-MB WAL segment. (I have a TODO
item about
I had postgresql die this morning because of lack of disk space
on /var (base grew to 422MB fairly quickly, and I'm not sure why
yet... pg_xlog is at 16450.
So, I thought I go in and look at some table sizes to try and
figure out what's so large, but I can't restart postmaster to
look at the tab
