On Fri, 2005-03-25 at 10:18 +0000, Simon Riggs wrote: > > When running with PostgreSQL 7.4 on a dual-CPU Athlon MP2400+ machine > > with a gigabyte of RAM, running Debian Linux version 2.6.8.1, we were > > able to insert all this data in 5-7 minutes. It's taken a while to > > install Postgres 8.0.1 on the same machine, but now I have, and it's > > taking 40-45 minutes to run the same insert script.
<snip> > OK. Not-a-bug. > > Your situation is covered in the manual with some sage advice > http://www.postgresql.org/docs/8.0/static/populate.html > It doesn't go into great lengths about all the reasons why those > recommendations are good ones - but they are clear. Simon, this begs the question: what changed from 7.4->8.0 to require he modify his script? TIA, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=- Mobile: (928) 699-9221 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])