[PERFORM] inserting into brand new database faster than old database

2004-07-07 Thread Missner, T. R.
Hello, I have been a happy postgresql developer for a few years now. Recently I have discovered a very strange phenomenon in regards to inserting rows. My app inserts millions of records a day, averaging about 30 rows a second. I use autovac to make sure my stats and indexes are up to date.

Re: [PERFORM] inserting into brand new database faster than old database

2004-07-07 Thread Missner, T. R.
the writes to disk are the bottleneck? T.R. Missner Level(3) Communications SSID tools Senior Software Engineer -Original Message- From: Matthew T. O'Connor [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 1:17 PM To: Missner, T. R. Cc: [EMAIL PROTECTED] Subject: Re: [PERFORM