I have an
application that I am porting from MySQL to PostgreSQL and I am working on the
import Perl script that process the data.
The data is web log
data and each line has a variable amount of the fields (mostly because of
cookies) so I am using a lot of insert statements.
In MySQL I go
through a file in about 2 minutes and it is taking about 30 in PG. I have
removed all but the primary key index and have done a BEGIN and COMMIT after
turning off AUTOCOMMIT.
What other things
should I be looking at to spped this up?
Dave
Waller
