Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D02A29FA37A for ; Tue, 6 Feb 2007 05:34:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 85548-01 for ; Tue, 6 Feb 2007 05:33:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.ecircle.de (mail.ecircle.de [195.140.186.200]) by postgresql.org (Postfix) with ESMTP id 89AA19FA312 for ; Tue, 6 Feb 2007 05:33:57 -0400 (AST) Received: from einstein.muc.ecircle.de (einstein.muc.ecircle.de [192.168.1.7]) by mail.ecircle.de (READY) with ESMTP id 1F55E55C00B; Tue, 6 Feb 2007 10:33:56 +0100 (CET) Received: from [192.168.1.91] ([192.168.1.91]) by einstein.muc.ecircle.de with Microsoft SMTPSVC(6.0.3790.1830); Tue, 6 Feb 2007 10:33:56 +0100 Subject: Re: How long should it take to insert 200,000 records? From: Csaba Nagy To: Karen Hill Cc: postgres performance list In-Reply-To: <1170722158.973141.208230@j27g2000cwj.googlegroups.com> References: <1170722158.973141.208230@j27g2000cwj.googlegroups.com> Content-Type: text/plain Message-Id: <1170754435.3101.122.camel@coppola.muc.ecircle.de> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 06 Feb 2007 10:33:56 +0100 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 06 Feb 2007 09:33:56.0044 (UTC) FILETIME=[EC0A50C0:01C749D1] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/59 X-Sequence-Number: 23113 On Tue, 2007-02-06 at 01:35, Karen Hill wrote: > [snip] 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. One way is to run analyze verbose on the target table and see how many pages it has, and then do it again 1 minute later and check how many pages it grew. Then multiply the page increase by the record per page ratio you can get from the same analyze's output, and you'll get an estimated growth rate. Of course this will only work if you didn't have lots of free space in the table to start with... if you do have lots of free space, you still can estimate the growth based on the analyze results, but it will be more complicated. In any case, it would be very nice to have more tools to attach to running queries and see how they are doing... starting with what exactly they are doing (are they in RI checks maybe ?), the actual execution plan they are using, how much they've done from their work... it would help a lot debugging performance problems. Cheers, Csaba.