On Tue, Dec 1, 2015 at 1:48 PM, Roxanne Reid-Bennett
wrote:
> On 11/30/2015 9:58 AM, David Kensiski wrote:
>
> I am working with a client who has a 9.1 database rapidly approaching XID
> wraparound. They also have an exceedingly large pg_largeobject table (4217
> GB) that
On Tue, Dec 1, 2015 at 9:12 AM, Jeff Janes wrote:
> On Mon, Nov 30, 2015 at 9:58 AM, David Kensiski
> wrote:
> > I am working with a client who has a 9.1 database rapidly approaching XID
> > wraparound.
>
> The hard limit at 2 billion, or the soft limit at
> autovacu
I am working with a client who has a 9.1 database rapidly approaching XID
wraparound. They also have an exceedingly large pg_largeobject table (4217
GB) that has never been vacuumed. An attempt to vacuum this on a replica
has run for days and never succeeded. (Or more accurately, never been
allo
