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.
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.
In response to
pgsql-sql by date
|Next:||From: Igor Neyman||Date: 2012-02-10 14:41:38|
|Subject: Re: Concurrent Reindex on Primary Key for large table|
|Previous:||From: Edward W. Rouse||Date: 2012-02-09 14:31:34|
|Subject: Re: time interval math|