I have a table that has only a few records in it at the time, and they
get deleted every few seconds and new records are inserted. Table never
has more than 5-10 records in it.
However, I noticed a deteriorating performance in deletes and inserts
on it. So I performed vacuum analyze on it three
On Mon, Feb 27, 2006 at 06:48:02 -0800,
Nik [EMAIL PROTECTED] wrote:
I have a table that has only a few records in it at the time, and they
get deleted every few seconds and new records are inserted. Table never
has more than 5-10 records in it.
However, I noticed a deteriorating
Nik [EMAIL PROTECTED] writes:
I have a table that has only a few records in it at the time, and they
get deleted every few seconds and new records are inserted. Table never
has more than 5-10 records in it.
However, I noticed a deteriorating performance in deletes and inserts
on it. So I
On 27/02/06, Chris Browne [EMAIL PROTECTED] wrote:
Nik [EMAIL PROTECTED] writes: I have a table that has only a few records in it at the time, and they get deleted every few seconds and new records are inserted. Table never
has more than 5-10 records in it. However, I noticed a deteriorating