i'm encountering an recurring problem in which running vacuum on a
relatively large
database ( >30000 rows) causes the database to corrupt rather badly. all
subsequent calls to vacuum does not return, and the only solution is to
pg_dump the database, drop all or some of the tables, and recover the
database using \i or psql -e.
i am working with version 7.0 .
is it a known bug ? was it solved on later versions? is there a
workaround?