Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ti02b-0004aj-Sc for pgsql-performance@arkaria.postgresql.org; Mon, 10 Dec 2012 09:52:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ti02a-00031e-Mp for pgsql-performance@arkaria.postgresql.org; Mon, 10 Dec 2012 09:52:48 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ti02Z-00031H-JS for pgsql-performance@postgresql.org; Mon, 10 Dec 2012 09:52:47 +0000 Received: from li188-192.members.linode.com ([178.79.132.192] helo=foo.me.uk) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ti02X-0001We-Si for pgsql-performance@postgresql.org; Mon, 10 Dec 2012 09:52:46 +0000 Received: from webmail.cantabcapital.com ([212.44.17.222] helo=CCPPRT350008) by foo.me.uk with esmtpa (Exim 4.71) (envelope-from ) id 1Ti0M6-0001y1-6F for pgsql-performance@postgresql.org; Mon, 10 Dec 2012 10:12:58 +0000 From: To: "'postgres performance list'" References: <092a01cdd230$ff6143c0$fe23cb40$@foo.me.uk> <097601cdd249$ae338530$0a9a8f90$@foo.me.uk> <1354979742.1963.11.camel@localhost.localdomain> In-Reply-To: <1354979742.1963.11.camel@localhost.localdomain> Date: Mon, 10 Dec 2012 09:52:42 -0000 Message-ID: <0dfe01cdd6bc$1986e900$4c94bb00$@foo.me.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQE7bKfasxp9xMk0I5yxURpgMQ+bBAG7NE8VAUNOjpIBq0cyVAKZw/XiAnxjE6yY6J78gA== Content-Language: en-gb X-SA-Exim-Connect-IP: 212.44.17.222 X-SA-Exim-Mail-From: pscott@foo.me.uk X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on foo.me.uk X-Spam-Level: X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,BAYES_00 autolearn=ham version=3.3.1 Subject: Re: Slow query: bitmap scan troubles X-SA-Exim-Version: 4.2.1 (built Sat, 07 Nov 2009 20:03:47 +0000) X-SA-Exim-Scanned: Yes (on foo.me.uk) X-Pg-Spam-Score: -1.9 (-) 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 > Greg's book is awesome. It really gives a lot of informations/tips/whatev= er on performances. I mostly remember all the informations about hardware, = OS, PostgreSQL configuration, and such. Not much on the EXPLAIN part. Arrived this morning :) > http://www.pgcon.org/2010/audio/15%20The%20PostgreSQL%20Query% > https://sites.google.com/site/robertmhaas/presentations > http://momjian.us/main/presentations/internals.html > http://www.dalibo.org/_media/understanding_explain.pdf Well that is my evenings occupied for the next week. Thank you kindly. - Phil --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance