Re: Concurrent Reindex on Primary Key for large table

> -----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
autovac
> performance? I am still doing a couple of concurrent reindexes per
week
> otherwise performance degrades over a couple of days.
>
> Thanks
> RV
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Concurrent-Reindex-on-Primary-
> Key-for-large-table-tp5467243p5470216.html
> 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?

Regards,
Igor Neyman