Postgres Pro
Downloads
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 20150316000415.2548.41321.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: Allow "snapshot too old" error, to prevent bloat  (Simon Riggs <simon@2ndQuadrant.com>)
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