Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 72A831337B96 for ; Mon, 1 Nov 2010 11:34:28 -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 81352-04 for ; Mon, 1 Nov 2010 14:34:22 +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 527211337B8D for ; Mon, 1 Nov 2010 11:34:20 -0300 (ADT) Received: from alap2.localnet (p579FA6DD.dip.t-dialin.net [87.159.166.221]) by mail.anarazel.de (Postfix) with ESMTPSA id 76DA7448003; Mon, 1 Nov 2010 15:34:19 +0100 (CET) From: Andres Freund To: Divakar Singh Subject: Re: Insert performance with composite index Date: Mon, 1 Nov 2010 15:34:17 +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> <201011011521.00144.andres@anarazel.de> <466107.20499.qm@web65410.mail.ac4.yahoo.com> In-Reply-To: <466107.20499.qm@web65410.mail.ac4.yahoo.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201011011534.17550.andres@anarazel.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/12 X-Sequence-Number: 41036 On Monday 01 November 2010 15:28:19 Divakar Singh wrote: > Do you mean these parameters have been removed starting 9.X? > As I see on > http://www.network-theory.co.uk/docs/postgresql/vol3/BackgroundWriter.html > ,these parameters were added starting from 8.0 right? No, I mean setting to 0 is a bit of a strange value in many situations. And you have comments like: #max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each #max_fsm_relations = 1000 # min 100, ~70 bytes each Which reference config options which do not exist anymore. And you have shared_buffers = 81920 Which indicates that you started from 8.1/8.2 or so... Andres