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 per

[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 ti

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 deterior

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.