How long should it take to insert 200,000 records?
Karen Hill <karen_hill22@yahoo.com>
From: "Karen Hill" <karen_hill22@yahoo.com>
To: pgsql-performance@postgresql.org
Date: 2007-02-06T00:35:59Z
Lists: pgsql-performance
I have a pl/pgsql function that is inserting 200,000 records for testing purposes. What is the expected time frame for this operation on a pc with 1/2 a gig of ram and a 7200 RPM disk? The processor is a 2ghz cpu. So far I've been sitting here for about 2 million ms waiting for it to complete, and I'm not sure how many inserts postgres is doing per second. regards, karen