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

BUG #3954: Duplicate Primary Keys

From: "Tapin Agarwal" <tapin(dot)agarwal(at)globallogic(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3954: Duplicate Primary Keys
Date: 2008-02-12 07:06:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3954
Logged by:          Tapin Agarwal
Email address:      tapin(dot)agarwal(at)globallogic(dot)com
PostgreSQL version: 8.1.2
Operating system:   Suse
Description:        Duplicate Primary Keys


We are using postgres-8.1.2 and observed the degradation in postgres
performance. Select query was taking very long time to complete. While on a
freshly installed postgres, with same number of records select query was
getting completed within seconds.

Our tables has indexes created on them and were running auto vacuum. Also we
are not using any table inheritance. When tried to perform re-indexing,
found that there were duplicate primary key entries in few of the tables.
This problem has occurred several times on our database setup and every time
different set of tables get affected.

Can you please let us know if this issue is already resolved in any of the
postgres releases. If it is then please let us know the release number.

Tapin Agarwal


pgsql-bugs by date

Next:From: Dave PageDate: 2008-02-12 09:15:14
Subject: Re: BUG #3953: No PostGIS option in installer
Previous:From: Rob von NesselrodeDate: 2008-02-11 22:22:42
Subject: BUG #3953: No PostGIS option in installer

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