Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E349264FD09 for ; Sat, 23 Aug 2008 07:30:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33198-07 for ; Sat, 23 Aug 2008 07:30:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nts.biz.ua (amn-trans.te.ua [217.196.165.165]) by postgresql.org (Postfix) with ESMTP id 1884464FE0F for ; Sat, 23 Aug 2008 07:30:25 -0300 (ADT) Received: from nts.biz.ua (localhost [127.0.0.1]) by nts.biz.ua (Postfix) with ESMTP id B60F1580630 for ; Sat, 23 Aug 2008 13:32:33 +0300 (EEST) Received: by nts.biz.ua (Postfix, from userid 1004) id AAD6958A708; Sat, 23 Aug 2008 13:32:33 +0300 (EEST) Received: from [10.0.0.14] (unknown [10.0.0.14]) by nts.biz.ua (Postfix) with ESMTP id 263C2580630 for ; Sat, 23 Aug 2008 13:32:31 +0300 (EEST) Message-ID: <48AFE6BB.6040400@nts.biz.ua> Date: Sat, 23 Aug 2008 13:30:19 +0300 From: DiezelMax User-Agent: Thunderbird 2.0.0.16 (X11/20080725) MIME-Version: 1.0 CC: pgsql-performance@postgresql.org Subject: Re: Large number of tables slow insert References: <1775c5ea0808221841u746862e3h1b721ea82fdb7794@mail.gmail.com> In-Reply-To: <1775c5ea0808221841u746862e3h1b721ea82fdb7794@mail.gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.581 tagged_above=0 required=5 tests=MISSING_HEADERS=1.581 X-Spam-Level: * X-Archive-Number: 200808/292 X-Sequence-Number: 31173 Each INDEX create a delay on INSERT. Try to measure performance w/o any indexes.