Re: Primary key vs unique index

From: rverghese <riyav(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Primary key vs unique index
Date: 2012-07-06 16:07:53
Message-ID: 1341590873296-5715712.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks
RV

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Primary-key-vs-unique-index-tp3883778p5715712.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ChoonSoo Park 2012-07-06 16:21:30 Re: Dynamic query execution using array
Previous Message Pavel Stehule 2012-07-06 15:45:42 Re: Dynamic query execution using array