| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Jeff Amiel <becauseimjeff(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Corrupt database? 8.1/FreeBSD6.0 |
| Date: | 2007-01-12 12:47:27 |
| Message-ID: | 20070112124727.GJ10446@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gellert, Andre | 2007-01-12 13:08:24 | Re: Need setup help for Postgresql 8.1.3 on Solaris 10 |
| Previous Message | Richard Huxton | 2007-01-12 12:28:23 | Re: plpgsql and arrays |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Amiel | 2007-01-12 13:48:35 | Re: Corrupt database? 8.1/FreeBSD6.0 |
| Previous Message | Gregory Stark | 2007-01-12 12:43:42 | Re: [PERFORM] unusual performance for vac following 8.2upgrade |