Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id AC0361337B51 for ; Mon, 1 Nov 2010 11:14:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 87727-08 for ; Mon, 1 Nov 2010 14:14:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40]) by mail.postgresql.org (Postfix) with ESMTP id 5B6361337B67 for ; Mon, 1 Nov 2010 11:14:35 -0300 (ADT) Received: from alap2.localnet (p579FA6DD.dip.t-dialin.net [87.159.166.221]) by mail.anarazel.de (Postfix) with ESMTPSA id A0837448003; Mon, 1 Nov 2010 15:14:34 +0100 (CET) From: Andres Freund To: Divakar Singh Subject: Re: Insert performance with composite index Date: Mon, 1 Nov 2010 15:14:31 +0100 User-Agent: KMail/1.13.5 (Linux/2.6.36-rc6-andres-00006-g4193d91; KDE/4.5.1; x86_64; ; ) Cc: pgsql-performance@postgresql.org References: <293254.80548.qm@web65413.mail.ac4.yahoo.com> <201011011503.51821.andres@anarazel.de> <359076.11138.qm@web65405.mail.ac4.yahoo.com> In-Reply-To: <359076.11138.qm@web65405.mail.ac4.yahoo.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201011011514.32217.andres@anarazel.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_20=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/8 X-Sequence-Number: 41032 On Monday 01 November 2010 15:08:10 Divakar Singh wrote: > here are my parameters: Which pg version is that?