Skip site navigation (1) Skip section navigation (2)

Re: Missing tables in postgresql 7.2.4

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 (view raw or flat)
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.

In response to

pgsql-bugs by date

Next:From: JKDate: 2005-05-12 03:35:28
Subject: BUG #1663: postgresql-8.0.msi Fails to Install
Previous:From: Ezequiel TolnayDate: 2005-05-12 01:48:38
Subject: Re: BUG #1659: primary key accepts null value

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group