| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-07-21 20:20:23 | Re: Re: dramatic slowdown. . .fixed by vacuum |
| Previous Message | Joe Slag | 2000-07-21 19:42:19 | Re: dramatic slowdown. . .fixed by vacuum |