Hi,
I'm trying to migrate a mysql database to postgresql. I've got the tables all set up, but inserting the data from the mysql dumps is taking forever. I've got about 200 million rows in the big table (growing by about 1.5 million per day), but at the 100 inserts/second I'm getting, this will take over 3 weeks. MySQL on the same machine averages about 1100-1200 inserts/second (no, I'm not running them both at the same time ;-)
Any thoughts on how to tweak the postmaster for quick inserts? I've got fsync turned off, but that's about all I've tried so far.
I'm running postgresql 7.1.3 on Linux (Redhat 7.2 with ext3) with a 700MHz processor, 256MB RAM, and an 80GB IDE HD
Thanks
-partap