Re: [GENERAL] XID wraparound with huge pg_largeobject

2015-12-02 Thread Jim Nasby
On 12/2/15 11:18 AM, Jeff Janes wrote: Is there a lot of free space in pg_largeobjects table (i.e. recently ran vacuumlo)? I wonder if it weren't doing a very slow backwards scan over the table in order to truncate away unused space. The problem is that the backwards scan might not trigger the

Re: [GENERAL] XID wraparound with huge pg_largeobject

2015-12-02 Thread Jeff Janes
On Wed, Dec 2, 2015 at 8:25 AM, David Kensiski wrote: > > > 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

Re: [GENERAL] XID wraparound with huge pg_largeobject

2015-12-02 Thread CS DBA
On 12/02/2015 09:36 AM, David Kensiski wrote: 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 a

Re: [GENERAL] XID wraparound with huge pg_largeobject

2015-12-02 Thread David Kensiski
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 has never been vacuumed

Re: [GENERAL] XID wraparound with huge pg_largeobject

2015-12-02 Thread David Kensiski
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 > autovacuum_freeze_max_age? > We're a

Re: [GENERAL] XID wraparound with huge pg_largeobject

2015-12-01 Thread Roxanne Reid-Bennett
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 has never been vacuumed. An attempt to vacuum this on a replica has run for days and never

Re: [GENERAL] XID wraparound with huge pg_largeobject

2015-12-01 Thread Jeff Janes
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 autovacuum_freeze_max_age? > They also have an exceedingly large pg_largeobject table (4217 > GB) th

[GENERAL] XID wraparound with huge pg_largeobject

2015-11-30 Thread David Kensiski
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