John Sidney-Woollett <johnsw@xxxxxxxxxxxxx> writes: > Just out of curiousity would the wraparound error (for mail_lxtreme) > actually have affected data in bp_live? > Could I just have deleted mail_lxtreme and then continued to use bp_live > as though nothing had happened? No, and yes, which is why panicking was not warranted ;-) Martijn's advice to be using "vacuumdb -a" every so often is well given, though. You could also consider switching over to autovacuum, particularly as of 8.1. (I'm not sure how much I trust the contrib version that exists in 8.0, and 7.4's is definitely pretty buggy, but I believe 8.1's can be relied on to prevent this sort of thing.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
