How long should it take to insert 200,000 records?

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How long should it take to insert 200,000 records?
Date: 2007-02-06 00:35:59
Message-ID: 1170722158.973141.208230@j27g2000cwj.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-02-06 05:33:35 Re: How long should it take to insert 200,000 records?
Previous Message Mark Stosberg 2007-02-05 23:01:05 Re: optimizing a geo_distance() proximity query (example and benchmark)