Postgres Pro
Downloads
Home   >   mailing lists

Wal -long transaction - Mailing list pgsql-general

From Agnes Bocchino
Subject Wal -long transaction
Date
Msg-id 441588D5.5050108@bull.net
Whole thread Raw
Responses Re: Wal -long transaction  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
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)

thanks
regards

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: in Pl/PgSQL, do commit every 5000 records
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Wal -long transaction