> -----Original Message-----
> From: rverghese [mailto:riyav(at)hotmail(dot)com]
> Sent: Thursday, February 09, 2012 12:49 PM
> To: pgsql-sql(at)postgresql(dot)org
> Subject: Re: Concurrent Reindex on Primary Key for large table
> Thanks! That worked.
> Any thoughts about containing index bloat. I thought the autovac would
> clean it up a bit more. Would any tweaks to my settings improve
> performance? I am still doing a couple of concurrent reindexes per
> otherwise performance degrades over a couple of days.
> View this message in context:
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
Did you try to make autovacuum "more aggressive" like lowering
autovacuum_vacuum_threshold from 20000?
In response to
pgsql-sql by date
|Next:||From: Oliveiros d'Azevedo Cristina||Date: 2012-02-10 15:33:09|
|Subject: Re: update column|
|Previous:||From: rverghese||Date: 2012-02-09 17:48:53|
|Subject: Re: Concurrent Reindex on Primary Key for large table|