Re: Insert statements really slow

On Nov 9, 2007 12:53 PM, Waller, David <Waller_D@imsdm.com> wrote:
> 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.

can you give us a better idea of the # records/sec we are talking
about here?  mysql and pg are usually pretty close in insert
performance.  maybe there is something fishy going on.

merlin