Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a3j2P-0004I5-O7 for pgsql-performance@arkaria.postgresql.org; Tue, 01 Dec 2015 11:24:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a3j2P-0000OL-9V for pgsql-performance@arkaria.postgresql.org; Tue, 01 Dec 2015 11:24:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a3j0j-0006xE-Mr for pgsql-performance@postgresql.org; Tue, 01 Dec 2015 11:22:18 +0000 Received: from nm29-vm8.bullet.mail.ir2.yahoo.com ([212.82.97.77]) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1a3j0h-000431-72 for pgsql-performance@postgresql.org; Tue, 01 Dec 2015 11:22:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1448968933; bh=+ngut+BOO4ID0MyGVAd3GUgQ7vIS2mI5STwpwKeId+M=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=IYmDugAOaLOtDyKTUS5bTcuV6MA+KGqsJL7vux9a3vug4nYmmst9RA64tdAMbgg01H7/lO7sD2bnzDkLEj3+H/2rNtgBGZ74+rmm2sIGJikduyNPE1VF0u4U6TI4vBBOvfTwSJ0awv4UYSe7jzhmPx2yAqjU0w+00EN907MrGyXNoLimN5OykNxJ0m/lKPoOgu3YPrwklmGjgsurFyMGWwjkWuE4Nuk/tcquFX0PhrdqqAJDPcjWzehjWOsAd3vRTegFMHOWXHY+ypJJr9W2ezO8DT1A9XAbf5tYjvB4Th+xukKVrZd9B3yIWeyetqO7XqZYOWVUOdF2jHG4Rep/XQ== Received: from [212.82.98.127] by nm29.bullet.mail.ir2.yahoo.com with NNFMP; 01 Dec 2015 11:22:13 -0000 Received: from [212.82.98.107] by tm20.bullet.mail.ir2.yahoo.com with NNFMP; 01 Dec 2015 11:22:13 -0000 Received: from [127.0.0.1] by omp1044.mail.ir2.yahoo.com with NNFMP; 01 Dec 2015 11:22:13 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 520347.34564.bm@omp1044.mail.ir2.yahoo.com X-YMail-OSG: cbQFUboVM1nLzq215ipVy989GzBdA_jQLH0ffAUeVFpXX_8JpnkQ..goKzmiIUX GSNdMVWcF39ckyQY7m6eOTu0T_WDX1WYh9fH15anEkgMhyvi6l2OL5RE2rWPB.bOLGaNh4IKDrV8 Jfcza9PZP0BCmgTbh8Gu2b2RG7gIdc24.BIxd8yOzofU4_E.9XbIv_oqaJZH0ftQIyM9v3VYh.Zt Utt.Fa.oYpeRy3Wh0O.naFE0Hlsg3ViyCcmLJCshtTz5QykpEbYdNuXWbrjWB0W6oQvkdxuTAXn1 ptHi_2AMjNy.OFRFbwPuYVyRhSev8vYMEGO90Cmp4f5HKXGpZhxb.hf4rRGK6BrH8tmQgbngH4hF eK0Pmp5N9pk1Xrk1MuBr4nOmw719V3zbnUsW26LbGcV65p.EjdOUBQJlnuCcQZnZ144ebocyrhdx YMU.4Tph7vLAHBA.TgcNiCfMVXc5VoadxKRPPSd.clOe.s0K_8ZLIgkcM77hkrYZAfBj7Yarxgiv hm74I96USm_vw Received: by 217.12.9.9; Tue, 01 Dec 2015 11:22:13 +0000 Date: Tue, 1 Dec 2015 11:22:12 +0000 (UTC) From: Glyn Astill Reply-To: Glyn Astill To: Jeff Janes Cc: Pgsql-performance Message-ID: <1810845895.22017405.1448968932390.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: Index scan cost calculation MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 277 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > >Clauses that can't be used in an "indexable" way are excluded from the >index selectivity, but not from the total query selectivity. > >> Or is it just likely that the selection of the new index is just by chance? > >Bingo. > Got it, thanks! Very much appreciated. Glyn -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance