Re: When do I Vacuum ? - Mailing list pgsql-general

From Peter Darley
Subject Re: When do I Vacuum ?
Date
Msg-id NNEAICKPNOGDBHNCEDCPMENCCBAA.pdarley@kinesis-cem.com
Whole thread Raw
In response to Re: When do I Vacuum ?  ("Steve Brett" <steve.brett@e-mis.com>)
List pgsql-general
Steve,
    Just to have an answer out there (being no expert); it seems to me that you
have very little traffic on your database, and vacuuming once a day is
probably plenty.
    My database has several thousand inserts/edits/deletes per day and I've
found that I don't have significant performance changes if I forget to
vacuum every day.

Thanks,
Peter Darley

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Brett
Sent: Monday, December 03, 2001 7:37 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] When do I Vacuum ?


could someone please post an answer, even if it's just a pointer to
somewhere else ... please ....
 :-)

Steve

"Steve Brett" <steve.brett@e-mis.com> wrote in message
news:9ufpug$217v$1@news.tht.net...
> hi,
>
> I've got a DB driven web application which currently has approx 298
inserts
> per day and 540 edits/deletes.
>
> This figure will change daily and currently i have a cron job set up to
> vacuum the database every hour during 'work time':
>
> 0 7-19/1,23 * * *       /usr/local/pgsql/bin/vacuumdb -z -d edb
> 30 7-19/4,23 * * *      /backup/dumpit
>
> I've also started reading Bruce's book (and what a fine book it is ... :-)
> and noticed that he suggests vacuuming once a day when the db is quiet.
>
> Would this be sufficient ? The database drives a web based
> calendar/appointment booking/reporting system i've written in php and is
> used extensively by 3 departments and has approx 200 people log in each
day.
>
> Needless to say speed it paramount but I've got a sneaky feeling I might
be
> vacuuming too often ....
>
> Many thanks for you help,
>
> Steve
>
>



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


pgsql-general by date:

Previous
From: "Hauke de Vries"
Date:
Subject: Access and Boolean
Next
From: "Gregory Wood"
Date:
Subject: Re: update returns 1, but no changes have been made