Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Oliver ElphickDate: 2005-10-26 13:18:40
Subject: Re: First Install
Previous:From: Williams, RodgerDate: 2005-10-26 11:01:47
Subject: Re: First Install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group