Re: Vacuum failed !

"Guillaume MARTIN" <guillaume@eurovox.fr> writes:
> i tried the truncate and delete ... I had the following :

> allopass_db=# DELETE FROM pg_statistic ;
> FATAL 2:  open of /var/pgsql/data/pg_clog/0022 failed: No such file or
> directory

I was afraid that wouldn't work, but it was worth a try.

> allopass_db=# TRUNCATE pg_statistic ;
> ERROR:  TRUNCATE cannot be used on system tables. 'pg_statistic' is a system
> table

You need to do the TRUNCATE in a standalone backend with -O -P switches.
This is basically the same procedure as for REINDEXing a system table;
see the REINDEX man page for details.

            regards, tom lane