X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D8652539A3; Fri, 1 Apr 2005 21:42:19 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53995-02; Fri, 1 Apr 2005 20:42:11 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E79AD539C4; Fri, 1 Apr 2005 21:42:10 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j31Kg8Q5028354; Fri, 1 Apr 2005 15:42:08 -0500 (EST) To: Christopher Petrilli Cc: "Marc G. Fournier" , pgsql-performance@postgresql.org Subject: Re: Sustained inserts per sec ... ? In-reply-to: <59d991c4050401113857086517@mail.gmail.com> References: <20050401140421.P18194@ganymede.hub.org> <59d991c4050401113857086517@mail.gmail.com> Comments: In-reply-to Christopher Petrilli message dated "Fri, 01 Apr 2005 14:38:36 -0500" Date: Fri, 01 Apr 2005 15:42:08 -0500 Message-ID: <28353.1112388128@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/15 X-Sequence-Number: 11412 Christopher Petrilli writes: > I can start at about 4,000 rows/second, but at about 1M rows, it > plummets, and by 4M it's taking 6-15 seconds to insert 1000 rows. > That's only about 15 rows/second, which is quite pathetic. The > problem seems to be related to my indexes, since I have to keep them > online (the system in continually querying, as well). I doubt it has anything to do with your indexes. I'm wondering about foreign key checks, myself. What FKs exist on these tables? Is the "start" condition zero rows in every table? Which PG version exactly? regards, tom lane