Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 56EC71337B51 for ; Mon, 1 Nov 2010 11:16:59 -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 77587-01 for ; Mon, 1 Nov 2010 14:16:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm7-vm0.bullet.mail.ac4.yahoo.com (nm7-vm0.bullet.mail.ac4.yahoo.com [98.139.52.228]) by mail.postgresql.org (Postfix) with SMTP id 7A7AB133729E for ; Mon, 1 Nov 2010 11:16:51 -0300 (ADT) Received: from [98.139.52.188] by nm7.bullet.mail.ac4.yahoo.com with NNFMP; 01 Nov 2010 14:16:50 -0000 Received: from [98.139.52.143] by tm1.bullet.mail.ac4.yahoo.com with NNFMP; 01 Nov 2010 14:16:50 -0000 Received: from [127.0.0.1] by omp1026.mail.ac4.yahoo.com with NNFMP; 01 Nov 2010 14:16:50 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 334648.12300.bm@omp1026.mail.ac4.yahoo.com Received: (qmail 74842 invoked by uid 60001); 1 Nov 2010 14:16:49 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1288621009; bh=kczTAusfjbpj5siWxffzSXxUEToYw99xPoAC1IuWUB8=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=T93gM06jH4UUK33c2dZ0luLn9Zi3pycRxXb06k/jPqB3dCrBvb/yl6Ti+1sGVNVUxNS0lZG/+hFzNJagsnjUOYUF53uz48zNVMx5s6jU8amgZXwAGShExbqWilQwclGvYCjezqAZKNTJIcm2DTVtdRApFIGcABhRhoSJFMw01fo= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=L5HjGexpN6bpMvV1ZnEJomg/5+MGHD4y17qgLmfuBpsb/P/hoLqJ5HqxY6Spv4KcM8y3wqHJcIYbFoBY9GAmYPiPAD/b1Qpyqjf34fE+IXgdvgclsS58bpC3YNBzn3RxOrlLPlwSWS9/WJZnLW8q9qqMurB1N279zin6nwGjQkk=; Message-ID: <521708.74664.qm@web65403.mail.ac4.yahoo.com> X-YMail-OSG: DADuRFUVM1km7AaVq8QchnCD_HaWMy7eecu4kvYFkFO.Wkq mz0CptZ.AkuQSjL9J.D1K7P2s7G0yP9yS2RUNo2CauRXCbKjmxsVIgBjEfo4 YRwGzT1OoVS60eGvQAZlqtMiVhjTDUNvB9MjSloxYAJNqqQrsM.Ih00rpmBm t3hQKD.35kJTdMiUNSNYG5tHb1yjpPZjzqkupQ9RUNCD3GooPN.IWiqMZSAg u01w26OYhz6NHUCcrUC_Xri23a0pQ6p6Sb3p0C3JLrWOsrF76bU9y1kio.LP m27IJHTVVREXNcQjzg0418xma76EBmQ6ttTa4zfY6k4GPjrvlPijt9Lmon4z cqnWvzYArUvk- Received: from [194.237.142.17] by web65403.mail.ac4.yahoo.com via HTTP; Mon, 01 Nov 2010 07:16:49 PDT X-Mailer: YahooMailRC/504.5 YahooMailWebService/0.8.107.284920 References: <293254.80548.qm@web65413.mail.ac4.yahoo.com> <201011011503.51821.andres@anarazel.de> <359076.11138.qm@web65405.mail.ac4.yahoo.com> <201011011514.32217.andres@anarazel.de> Date: Mon, 1 Nov 2010 07:16:49 -0700 (PDT) From: Divakar Singh Subject: Re: Insert performance with composite index To: Andres Freund Cc: pgsql-performance@postgresql.org In-Reply-To: <201011011514.32217.andres@anarazel.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1197770503-1288621009=:74664" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.01 tagged_above=-10 required=5 tests=BAYES_20=-0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/9 X-Sequence-Number: 41033 --0-1197770503-1288621009=:74664 Content-Type: text/plain; charset=us-ascii I am using 9.0.1 Best Regards, Divakar ________________________________ From: Andres Freund To: Divakar Singh Cc: pgsql-performance@postgresql.org Sent: Mon, November 1, 2010 7:44:31 PM Subject: Re: [PERFORM] Insert performance with composite index On Monday 01 November 2010 15:08:10 Divakar Singh wrote: > here are my parameters: Which pg version is that? --0-1197770503-1288621009=:74664 Content-Type: text/html; charset=us-ascii
I am using 9.0.1
 
Best Regards,
Divakar



From: Andres Freund <andres@anarazel.de>
To: Divakar Singh <dpsmails@yahoo.com>
Cc: pgsql-performance@postgresql.org
Sent: Mon, November 1, 2010 7:44:31 PM
Subject: Re: [PERFORM] Insert performance with composite index

On Monday 01 November 2010 15:08:10 Divakar Singh wrote:
> here are my parameters:
Which pg version is that?

--0-1197770503-1288621009=:74664--