Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B472E9FB2A6 for ; Mon, 5 Feb 2007 20:36:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 85929-08 for ; Mon, 5 Feb 2007 20:36:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id D83829FA371 for ; Mon, 5 Feb 2007 20:36:09 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3207B308E2; Tue, 6 Feb 2007 01:36:07 +0100 (MET) From: "Karen Hill" X-Newsgroups: pgsql.performance Subject: How long should it take to insert 200,000 records? Date: 5 Feb 2007 16:35:59 -0800 Organization: http://groups.google.com Lines: 10 Message-ID: <1170722158.973141.208230@j27g2000cwj.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1) Gecko/20061010 Firefox/2.0,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: j27g2000cwj.googlegroups.com; posting-host=209.102.127.196; posting-account=UskOZg0AAABeGutYp_rJHX2WGbDZ3a_l To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.905 tagged_above=0 required=5 tests=AWL, BAYES_40, FORGED_YAHOO_RCVD, FROM_HAS_ULINE_NUMS X-Spam-Level: * X-Archive-Number: 200702/55 X-Sequence-Number: 23109 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