Re: Primary key vs unique index

On Fri, Jul 06, 2012 at 09:07:53AM -0700, rverghese wrote:
> We are experiencing a similar problem, even though we are on 8.4 and have
> been for a while, and have autovacuum turned on. I have regular concurrent
> reindexes on the indexes but the primary key is seriously bloated. I was
> considering doing the same thing, that is, create another primary key that
> is built on a sequence ( primarily for slony) and then change my current
> multi-column primary key to a unique index. Have you been able to work
> around the problem in any other way?

http://www.depesz.com/2011/07/06/bloat-happens/

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/