I'm using 8.1 on XP. Server disk becomes full during running ANALYSE command. The following lines are in log file 2005-12-06 18:29:10 ERROR: duplicate key violates unique constraint "pg_statistic_relid_att_index" 2005-12-06 18:30:23 LOG: autovacuum: processing database "postgres" 2005-12-06 18:31:18 ERROR: could not extend relation 1663/74856/2696: No space left on device 2005-12-06 18:31:18 HINT: Check free disk space. 2005-12-06 18:31:29 WARNING: corrupted pgstat.stat file 2005-12-06 18:32:37 LOG: autovacuum: processing database "template1" 2005-12-06 18:32:39 LOG: could not close temporary statistics file "global/pgstat.tmp": No space left on device 2005-12-06 18:32:40 LOG: could not close temporary statistics file "global/pgstat.tmp": No space left on device 2005-12-06 18:33:42 LOG: autovacuum: processing database "template1" 2005-12-06 18:34:42 LOG: autovacuum: processing database "foo" 2005-12-06 18:35:53 LOG: autovacuum: processing database "bar" 2005-12-06 18:37:12 LOG: autovacuum: processing database "postgres" 2005-12-06 18:38:13 LOG: autovacuum: processing database "template1" etc. Should I fix something or can I continue to use this cluster normally ? Andrus.
