| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Wal -long transaction |
| Date: | 2006-03-13 15:05:41 |
| Message-ID: | 20060313150541.GH6714@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)org> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-13 15:20:24 | Re: Wal -long transaction |
| Previous Message | Niklas Johansson | 2006-03-13 15:03:41 | Re: Problem getting plpgsql to choose the right query plan |