The following bug has been logged online: Bug reference: 3954 Logged by: Tapin Agarwal Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Suse Description: Duplicate Primary Keys Details:
Hi, 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. Regards, Tapin Agarwal ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly