Re: vacuuming and manu updates

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.