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

Re: Re: dramatic slowdown. . .fixed by vacuum

From: "Anthony E (dot) Greene" <agreene(at)pobox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Re: dramatic slowdown. . .fixed by vacuum
Date: 2000-07-21 20:20:22
Message-ID: 20000721222022.A1998@fmo-fly-5 (view raw or flat)
Thread:
Lists: pgsql-novice
On 21 Jul 2000 21:42 Joe Slag wrote:
>I see in the docs the suggestion: 
>
>    We recommend that active production databases be VACUUMM-ed nightly
>
>Is this how people tend to do their vacuuming?  Does anyone do
programmatic
>vacuums instead of / in addition to a nightly run?  Is vacuuming mainly
>necessary after big deletes, or are there other common situations 
>requiring it?

I run vacuum as part of a cron job each month. My databases are small and
90% of the activity is SELECTs.

-- 
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Linux. The choice of a GNU Generation. <http://www.linux.org/>

In response to

pgsql-novice by date

Next:From: The Hermit HackerDate: 2000-07-21 20:20:23
Subject: Re: Re: dramatic slowdown. . .fixed by vacuum
Previous:From: Joe SlagDate: 2000-07-21 19:42:19
Subject: Re: dramatic slowdown. . .fixed by vacuum

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