duplicate key in unique index pg_statistic_relid_att_index

Started by Andrew Bartleyover 23 years ago2 messagesgeneral
Jump to latest
#1Andrew Bartley
abartley@evolvosystems.com

Hi,

We are running postgres 7.2.

On a regular basis now I am getting duplicate keys in unique index pg_statistic_relid_att_index. Could this be cause by in insert into a table that is being "vacuum analyse" 'd ?

I have tried reindexing the database, but it always fails because there are duplicate rows in pg_statisitic. This leads to even more problems because the object for the index in data/base disappears.

I have checked all my application code. But inserting while vacuuming is somthing I am not sure about.

The inserts are comming from a client using pg_connect. A vacuum analyse on certain tables while inserts are being executed is very possible.

I am going to change the code to "vacuum full analyse" in our test regions. But this is not ideal in our production regions.

Thanks

Andrew

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andrew Bartley (#1)
Re: duplicate key in unique index pg_statistic_relid_att_index

"Andrew Bartley" <abartley@evolvosystems.com> writes:

On a regular basis now I am getting duplicate keys in unique index pg_stati=
stic_relid_att_index.

This is most curious. AFAICS it should not be possible.

Could this be cause by in insert into a table that i=
s being "vacuum analyse" 'd ?

Nope.

I have tried reindexing the database, but it always fails because there are=
duplicate rows in pg_statisitic.

Do a "DELETE FROM pg_statistic" and then re-analyze everything; should
fix it.

regards, tom lane