Were other queries occurring during your vacuum? There have been reports
in these mailing lists that concurrent queries cause vacuum failures...
Cheers,
Ed Loehr
Adriaan Joubert wrote:
> Hi,
>
> Something in my pg_proc table got corrupted and when trying to
> vacuum it, vacuum would create thousands of index files in the database
> directory. It would just go into an endless loop and all it seems to do
> is create files. Anybody else seen this before? I've tried everything
> and am now in the process of dumping all the data out table by table and
> rebuilding the database from scratch. Any ideas what I can do to avoid
> this or any idea how this could have happened? I'm running 6.5.2 on
> Digital Unix 4.0F.
>
> Cheers,
>
> Adriaan
>
> ************
