Re: Concurrent Reindex on Primary Key for large table

From: rverghese <riyav(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Concurrent Reindex on Primary Key for large table
Date: 2012-02-09 17:48:53
Message-ID: 1328809733573-5470216.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Igor Neyman 2012-02-10 14:41:38 Re: Concurrent Reindex on Primary Key for large table
Previous Message Edward W. Rouse 2012-02-09 14:31:34 Re: time interval math