Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group