Re: [ADMIN] Resolving Index Bloat

2012-11-20 Thread Samuel Stearns
] Resolving Index Bloat Samuel -- > > From: Samuel Stearns >To: "pgsql-admin@postgresql.org" >Sent: Monday, November 19, 2012 1:59 PM >Subject: [ADMIN] Resolving Index Bloat > > ><...> > >Any ideas on how to resolv

Re: [ADMIN] Resolving Index Bloat

2012-11-19 Thread Samuel Stearns
in@postgresql.org Subject: Re: [ADMIN] Resolving Index Bloat Samuel Stearns writes: > We have a problem with index bloat on a couple of our tables even though we > have applied more aggressive autovac/analyze settings in the schema: Hard to tell much about this without knowing the baselin

Re: [ADMIN] Resolving Index Bloat

2012-11-19 Thread Samuel Stearns
ADMIN] Resolving Index Bloat Samuel Stearns writes: > We have a problem with index bloat on a couple of our tables even though we > have applied more aggressive autovac/analyze settings in the schema: Hard to tell much about this without knowing the baseline condition or what's ha

Re: [ADMIN] Resolving Index Bloat

2012-11-19 Thread Tom Lane
Samuel Stearns writes: > We have a problem with index bloat on a couple of our tables even though we > have applied more aggressive autovac/analyze settings in the schema: Hard to tell much about this without knowing the baseline condition or what's happened since the baseline. It looks like yo

Re: [ADMIN] Resolving Index Bloat

2012-11-19 Thread Greg Williamson
Samuel -- > > From: Samuel Stearns >To: "pgsql-admin@postgresql.org" >Sent: Monday, November 19, 2012 1:59 PM >Subject: [ADMIN] Resolving Index Bloat > > ><...> > >Any ideas on how to resolve? >  I have

[ADMIN] Resolving Index Bloat

2012-11-19 Thread Samuel Stearns
Howdy, Enviroment: Postgres 8.4.14 Linux We have a problem with index bloat on a couple of our tables even though we have applied more aggressive autovac/analyze settings in the schema: ALTER TABLE billingitemrating SET (autovacuum_vacuum_scale_factor=0.001, autovacuum_analyze_scale_factor=0.