Dmitry Tkach <[EMAIL PROTECTED]> writes:Oops... I just got it again - right after doing that select count (*), that *worked*, I tried analyze the same table, and got:
Well ... *today* there seem to be files between 0000 and 00EC
Is that range supposed to stay the same or does it vary?
It will vary, but not quickly --- each file represents 1 million transactions.
If the problem is erratic with VACUUM or SELECT COUNT(*), then the
only speculation I have is flaky hardware: you must be reading different
xids from the table at different times.
FATAL 2: open of /var/lib/pgsql/data/pg_clog/0980 failed: No such file or directory
I tried it again, right away, and got the same error, complaining about 02B0 this time
I tried select count (*) again, and it worked.
I restarted the server, did analyze, and it worked too...
Any ideas?
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
