> Currently, I've got a python script using pyPgSQL that
> parses the CSV record, creates a string that is a big
> "INSERT INTO VALUES (...)" command, then, execute() it.
What's wrong with the COPY command?
> top shows that this method uses postmaster with ~70% CPU
> utilization, and python with ~15% utilization.
> Still, it's only inserting ~190 recs/second. Is there a
> better way to do this, or am I constrained by the hardware?
This sounds pretty good for an ATA system. Upgrading to SCSI-RAID will also
improve your performance.
In response to
pgsql-novice by date
|Next:||From: Victor Manuel Torres Aguirre||Date: 2002-05-22 00:50:33|
|Subject: PostgreSQL+Access97+Linux: How to..|
|Previous:||From: Tom Lane||Date: 2002-05-21 23:27:47|
|Subject: Re: Large tables being split at 1GB boundary |