> > We have a fresh database and have begun to observe performance > > degradation for INSERTs as a table went from empty to 100,000-ish > > rows. Initial INSERTs were sub second while after 30k rows, they > > were 1-3 seconds. > > we just hit this problem when moving old database to new one (new > schema). we had to insert approx. 1.5 million rows, and from > initial 0.02s/insert after several thousands of inserts it came to > 20 seconds per insert. what we did was removing foreign keys from > table which we made inserts to. it helped. we manage to put 300k > records in ca. 2-3 hours.
If possible, use the COPY command. We did 90K rows in about 40sec using this puppy on a Solaris U5 (took over 130sec for MySQL on the same box in case the performance geeks in the crowd are interested). http://www.postgresql.org/idocs/index.php?sql-copy.html -sc -- Sean Chittenden ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
