Re: Reduce pinning in btree indexes - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Reduce pinning in btree indexes
Date
Msg-id CAM-w4HPRnMDXc1xSo9RvvbxTvoypxSg2CjwLZ9vjgsMyxqpCbw@mail.gmail.com
Whole thread Raw
In response to Re: Reduce pinning in btree indexes  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers

On Sat, Mar 14, 2015 at 4:07 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
-1 for a time based setting.

After years of consideration, bloat is now controllable by altering
the size of the undo tablespace.

Hm. Well, fwiw the situation is rather more complicated than that. You're correct that you can create a fixed size undo tablespace in which case Oracle will tell you approximately how much retention period you can rely on given that size. But alternately you can set the undo tablespace to be autoextend and Oracle will tune it to ensure there's enough retention to cover the longest-running query in the system. You can also set a time-based parameter (undo_retention) to ensure there's always at least enough data retained to cover a fixed amount of time for flashback (Oracle's equivalent to our time travel feature in ancient versions of Postgres).
 

--
greg

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Install shared libs in lib/ and bin/ with MSVC (Was: install libpq.dll in bin directory on Windows / Cygwin)
Next
From: Bruce Momjian
Date:
Subject: Re: "cancelling statement due to user request error" occurs but the transaction has committed.