Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0F8B7B5D80A for ; Sun, 22 May 2011 03:38:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 71211-05 for ; Sun, 22 May 2011 06:38:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nm4-vm0.bullet.mail.ird.yahoo.com (nm4-vm0.bullet.mail.ird.yahoo.com [77.238.189.211]) by mail.postgresql.org (Postfix) with SMTP id 69454B5D801 for ; Sun, 22 May 2011 03:38:23 -0300 (ADT) Received: from [77.238.189.231] by nm4.bullet.mail.ird.yahoo.com with NNFMP; 22 May 2011 06:38:21 -0000 Received: from [212.82.108.250] by tm12.bullet.mail.ird.yahoo.com with NNFMP; 22 May 2011 06:38:21 -0000 Received: from [127.0.0.1] by omp1015.mail.ird.yahoo.com with NNFMP; 22 May 2011 06:38:21 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 364857.89535.bm@omp1015.mail.ird.yahoo.com Received: (qmail 25791 invoked by uid 60001); 22 May 2011 06:38:21 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.it; s=s1024; t=1306046301; bh=q3rnHEG2Dk0h2cW9YD0B47Bh7CRJHCHu1AVHd3SPZUM=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Vr9b3FAzfv9sqLwIyuBI5bdE1IoJJQv3YiYtgWezOj355oYADs8VxhspQyVfvdtkF5QYQ3vJTDhVaohrxCOzRHvKOw/+CYorMcNobk6S73IuUi+vwLBHvPM/ki+vYTwuEPvQhmkp8MPvU6a6/H8wo/IrIrd5oEMLtfBZLHQZgQU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.it; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=RKmiU63BEpgP1okJDIwQy+5Nwutivjwd93mYcUcBmzQjb/BcK/wq9lvcU6h2J1XbexUHNC/wlv5rXqzU9vKEiH/IBLfQBC7Kj08n0IFNHUd5JYK3/XYQojEPY+24oIWxULXWizUuKOpN2NvQGo7QdK3Hjwo/het6/b4vH71IX/M=; Message-ID: <163903.24886.qm@web29019.mail.ird.yahoo.com> X-YMail-OSG: v.XKXFsVM1m38Cssyc7JjQdotnbjgl.uU69GAn563fO3YcB YFcm45gVmuXhORa5V8jYhTqnrLlBrg4v5c0sN5Q6gP8Bo.ZTZU_Phe__TRII aSzGY2biTubvzTfw10Eecs6itd0vuW_zROmMTkorftgZlzwbiOnB9EulNlc7 dKN39FQxoMn5CXMHPHnbQhkx7AJ1iQlIJDI4Lw9UIEjsp6yz5CKasJn2O2oN b9GwoZxnXe8KEJsjw7iM8BbA4BRRgyCWs8kKjDkCyRSwoIiBFvZF5.e.mBpM LOqxJE_D5ha6_RkeDwJqq_R7z.ZF1rHssMT1DMWbZ4qd3IPAe6mwd6GvH Received: from [151.82.15.155] by web29019.mail.ird.yahoo.com via HTTP; Sun, 22 May 2011 07:38:20 BST X-Mailer: YahooMailRC/567 YahooMailWebService/0.8.111.303096 References: Date: Sun, 22 May 2011 07:38:20 +0100 (BST) From: Leonardo Francalanci Subject: Re: Performance degradation of inserts when database size grows To: Andrey Vorobiev , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201105/290 X-Sequence-Number: 43799 =0A=0A>1. How does database size affect insert performance?=0A>2. Why does = number of written buffers increase when database size grows?=0A=0AIt might = be related to indexes. Indexes size affect insert performance.=0A=0A>3. How= can I further analyze this problem?=0A=0A=0ATry without indexes?