Martijn van Oosterhout wrote:
On Mon, Mar 13, 2006 at 03:59:33PM +0100, Agnes Bocchino wrote:
I would like to know how Postgresql works when all the files
(checkpoint_segment *2 + 1)
are full ,
does Postgresql rollback the transaction when all the wal segments are used,
or does the server stop with an error message ?
(I have tried to make the test but without success for finding a long
transaction)
AIUI it just keeps creating more segments. i.e. checkpoint_segment is
not a hard limit. It's just the number it keeps around and recycles
rather than continually creating and deleteing files.
Have a nice day,
Thanks for the answer, that's clarify how it's work
I ask this question about 'long transaction' (between two commits)
because it was a problem on old release of IDS Informix.
Please, what is the meaning of 'AIUI' ......
Thanks
Agnès
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
