> we are using PostgreSQL 6.4.2 under FreeBSD 2.2.8.
> At a customers site we start vacuum nightly and for almost two weeks it
> has always run successfully. Now it fails and a 'vacuum verbose', run
blow away anything that can be re-created, or not needed (ie. indexes and
temp tables).
then vacuum again, rebuild indexes and away you go.
works for me.
--
[ Jim Mercer Reptilian Research jim@reptiles.org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]