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