From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | kadil <ksadil(at)bigpond(dot)net(dot)au> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: vacuuming and manu updates |
Date: | 2005-10-26 18:17:38 |
Message-ID: | 20051026181738.GE11447@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Oct 26, 2005 at 21:12:55 +1000,
kadil <ksadil(at)bigpond(dot)net(dot)au> wrote:
> Hi,
>
> I have a small table (100 rows) and I update its values every 8 seconds. This
> leads to poor performance until I vacuum. pg8.0 on w2000. Any suggestions on
> how often to vacuum or would I be better off doing delete and inserts for
> improved sustainable performance
How many rows do you update in this table every 8 seconds?
You might do a vacuum once a minute. However, if you are only updating a couple
of rows each pass, than every 5 minutes may be plenty.
Note that an update is effectively an insert and delete, so changing updates
to inserts and deletes isn't going to help performance.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Crenshaw | 2005-10-26 19:39:42 | Re: psql goes away in a flash |
Previous Message | Andrej Ricnik-Bay | 2005-10-26 17:27:16 | Re: psql goes away in a flash |