Postgres Pro
Downloads
Home   >   mailing lists

Re: Concurrent Reindex on Primary Key for large table - Mailing list pgsql-sql

From rverghese
Subject Re: Concurrent Reindex on Primary Key for large table
Date
Msg-id 1328809733573-5470216.post@n5.nabble.com
Whole thread Raw
In response to Re: Concurrent Reindex on Primary Key for large table  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Concurrent Reindex on Primary Key for large table  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: "Edward W. Rouse"
Date:
Subject: Re: time interval math
Next
From: "Igor Neyman"
Date:
Subject: Re: Concurrent Reindex on Primary Key for large table