Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 02C2D1337990 for ; Mon, 1 Nov 2010 11:21:10 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 28425-09 for ; Mon, 1 Nov 2010 14:21:02 +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 B2EFD1337B5E for ; Mon, 1 Nov 2010 11:21:02 -0300 (ADT) Received: from alap2.localnet (p579FA6DD.dip.t-dialin.net [87.159.166.221]) by mail.anarazel.de (Postfix) with ESMTPSA id 17763448003; Mon, 1 Nov 2010 15:21:02 +0100 (CET) From: Andres Freund To: Divakar Singh Subject: Re: Insert performance with composite index Date: Mon, 1 Nov 2010 15:20:59 +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> <201011011514.32217.andres@anarazel.de> <521708.74664.qm@web65403.mail.ac4.yahoo.com> In-Reply-To: <521708.74664.qm@web65403.mail.ac4.yahoo.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201011011521.00144.andres@anarazel.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.51 tagged_above=-10 required=5 tests=BAYES_05=-0.5, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/10 X-Sequence-Number: 41034 On Monday 01 November 2010 15:16:49 Divakar Singh wrote: > I am using 9.0.1 Either thats not true or you cargo culted loads of your config from a significantly older pg version. Things like: #bgwriter_delay = 200 # 10-10000 milliseconds between rounds bgwriter_lru_percent = 0 # 0-100% of LRU buffers scanned/round #bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round #bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned/round bgwriter_all_maxpages = 0 # 0-1000 buffers max written/round make me very suspicious. As I said, I would check the variables I referenced in my first post... Andres