Wal -long transaction

From: Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Wal -long transaction
Date: 2006-03-13 14:59:33
Message-ID: 441588D5.5050108@bull.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Niklas Johansson 2006-03-13 15:03:41 Re: Problem getting plpgsql to choose the right query plan
Previous Message Merlin Moncure 2006-03-13 14:55:09 Re: in Pl/PgSQL, do commit every 5000 records