Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group