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

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