Jeff Amiel wrote: > Sure enough I did make autovacuum more agressive about 30-45 days ago (have > to check the logs to find the exact date). Was originally whatever default > settings that came out of the box with 8.1. Naptime is currently set to 60 > seconds. > > Am I to assume that this probably isn't the result of some operating system > or filesystem misfeasance and that corrupt data in my 'real' databases is > probably not an issue?
Did you perchance connect to template0 (probably marking it as connectable in the process), made some modification there, and then mark it as non-connectable again, without executing VACUUM FREEZE on it? AFAICS we only execute VACUUM FREEZE on it, so we shouldn't leave any unfrozen tuples. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
