[PERFORM] Large Table With Only a Few Rows

2006-02-28 Thread Nik
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

Re: [PERFORM] Large Table With Only a Few Rows

2006-02-28 Thread Bruno Wolff III
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

Re: [PERFORM] Large Table With Only a Few Rows

2006-02-27 Thread Chris Browne
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

Re: [PERFORM] Large Table With Only a Few Rows

2006-02-27 Thread Peter Childs
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