vacuuming and manu updates

From: kadil <ksadil(at)bigpond(dot)net(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: vacuuming and manu updates
Date: 2005-10-26 11:12:55
Message-ID: 200510262112.55409.ksadil@bigpond.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Thanks,
Kim

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2005-10-26 13:18:40 Re: First Install
Previous Message Williams, Rodger 2005-10-26 11:01:47 Re: First Install