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