Roberto Fichera <kernel@tekno-soft.it> writes:
> database=# select count(*) from detail;
> count
> --------
> 181661
> (1 row)
> database=# select count(*) from detail;
> count
> --------
> 181660
> (1 row)
> database=# select count(*) from detail;
> FATAL 2: open of /var/lib/pgsql/data/pg_clog/0303 failed: No such file or
> directory
[ blinks... ] That's with no one else modifying the table meanwhile?
I think you've got *serious* hardware problems. Hard to tell if it's
disk or memory, but get out those diagnostic programs now ...
regards, tom lane