On Sun, 20 Oct 2002, geva wrote: > > 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?
It's hard to say, there have been bugs related to vacuum fixed in later versions. 7.0 is pretty old at this point (between 2 and 3 revisions back since 7.3 is in beta), you'd probably be best off upgrading if possible. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
