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, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
signature.asc
Description: Digital signature
