Re: INSERT performace.

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