Request a Demo
Home   >   mailing lists

Re: Allow "snapshot too old" error, to prevent bloat - Mailing list pgsql-hackers

From Rui DeSousa
Subject Re: Allow "snapshot too old" error, to prevent bloat
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Allow "snapshot too old" error, to prevent bloat  (Simon Riggs <[email protected]>)
Responses Re: Allow "snapshot too old" error, to prevent bloat
Re: Allow "snapshot too old" error, to prevent bloat
List pgsql-hackers
Tree view 
Would a parameter to auto terminate long running transactions be a better solution? Terminating the long running
transactionwould allow for the normal vacuuming process to cleanup the deleted records thus avoiding database bloat
withoutintroducing new semantics to Postgres's MVCC. I would also recommend that the default be disabled.

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Faster setup_param_list() in plpgsql
Next
From: Gavin Flower
Date:
Subject: Re: Allow "snapshot too old" error, to prevent bloat