| From: | Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Wal -long transaction |
| Date: | 2006-03-13 15:51:03 |
| Message-ID: | 441594E7.6070601@bull.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-03-13 15:51:26 | Re: Wal -long transaction |
| Previous Message | Tom Lane | 2006-03-13 15:32:23 | Re: FATAL: terminating connection due to administrator command |