"Andrew Bartley" <abartley(at)evolvosystems(dot)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