Home > mailing lists

vacuuming and manu updates - Mailing list pgsql-novice

From	kadil
Subject	vacuuming and manu updates
Date	October 26, 2005 11:13:00
Msg-id	200510262112.55409.ksadil@bigpond.net.au Whole thread Raw
Responses	Re: vacuuming and manu updates Re: vacuuming and manu updates
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: "Williams, Rodger"
Date: 26 October 2005, 11:01:53
Subject: Re: First Install

From: Oliver Elphick
Date: 26 October 2005, 13:29:33
Subject: Re: First Install

vacuuming and manu updates - Mailing list pgsql-novice

Previous

Next