| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | Michael Beckstette <mbeckste(at)TechFak(dot)Uni-Bielefeld(dot)DE> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Missing tables in postgresql 7.2.4 |
| Date: | 2005-05-12 01:57:54 |
| Message-ID: | 4282B822.2040505@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> P.S.:A TODO for me: CRON Script for weekly VACUUM ;)
on heavy use databases, mine generally does a light vacuum every 4 hours, and a
once a day full on everything. also, a weekly full reindex on a really really
heavy use systems like this one message board server I ad-mangle
something like...
7 */4 * * * vacuumdb busy_database >/dev/null 2>/dev/null
37 0 * * * vacuumdb -a -z >/dev/null 2>/dev/null
37 2 * * Sun reindexdb -a > /dev/null 2>/dev/null
many might say this is total overkill, I dunno. keeps this server happy. btw,
reindexdb is a script from contrib.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JK | 2005-05-12 03:35:28 | BUG #1663: postgresql-8.0.msi Fails to Install |
| Previous Message | Ezequiel Tolnay | 2005-05-12 01:48:38 | Re: BUG #1659: primary key accepts null value |