> Just curious, but does anyone have an idea of what we are capable of?  I 
> realize that size of record would affect things, as well as hardware, but 
> if anyone has some ideas on max, with 'record size', that would be 
> appreciated ...

Well, I just did an insert of 27,500 records with 9 fields, averaging 
around 118 bytes per record, each insert statement coming from a separate 
SQL statement fed to psql, and it took a bit over 4 minutes, or about 
106 inserts per second.

That seems consistent with what I get when I do a restore of a dump
file that has insert statement instead of COPY.

The hardware is a Dell dual Xeon system, the disks are mirrored SATA
drives with write buffering turned off.  
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to