Postgres Pro
Downloads
Home   >   mailing lists

Thread: vacuum analyze - cannot insert duplicate key... (2)

vacuum analyze - cannot insert duplicate key... (2)

From
Patrick Coulombe
Date:
in my data/base/medias/
medias_categories_media_id_key.999

i found this file over 700 copy. can i erase them and what the purpose of
this file ?

patrick

Re: vacuum analyze - cannot insert duplicate key... (2)

From
Tom Lane
Date:
Patrick Coulombe <pcoulombe@mediacces.com> writes:
> in my data/base/medias/
> medias_categories_media_id_key.999
> i found this file over 700 copy. can i erase them and what the purpose of
> this file ?

If they're zero-length, you can remove them.  You definitely need to
update, though; appearance of such files is a symptom of some old bugs.

            regards, tom lane