Postgres Pro
Downloads
Home   >   mailing lists

Optimize for insertions? - Mailing list pgsql-general

From Gurupartap Davis
Subject Optimize for insertions?
Date
Msg-id 004901c176bf$b03ccbd0$0f00a8c0@marlows
Whole thread Raw
Responses Re: Optimize for insertions?  (Jeff Davis <list-pgsql-general@dynworks.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Sheer El-Showk
Date:
Subject: Re: Strange performance issue
Next
From: Jeff Davis
Date:
Subject: Re: Optimize for insertions?