X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 839FFD7066 for ; Fri, 26 Aug 2005 10:10:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81936-01 for ; Fri, 26 Aug 2005 13:10:18 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id 314B1D6FEF for ; Fri, 26 Aug 2005 10:10:16 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id B87C440DCD2; Fri, 26 Aug 2005 14:10:11 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 991FC15EDA; Fri, 26 Aug 2005 14:05:56 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06572-01; Fri, 26 Aug 2005 14:05:53 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 0497D15EDE; Fri, 26 Aug 2005 14:05:24 +0100 (BST) Message-ID: <430F1393.5040704@archonet.com> Date: Fri, 26 Aug 2005 14:05:23 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Arjen van der Meijden Cc: pgsql-performance@postgresql.org Subject: Re: Inefficient queryplan for query with intersectable References: <430EF844.70905@tweakers.net> In-Reply-To: <430EF844.70905@tweakers.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.057 required=5 tests=[AWL=0.007, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/436 X-Sequence-Number: 14183 Arjen van der Meijden wrote: > > I left all the configuration-stuff to the defaults since changing values > didn't seem to impact much. Apart from the buffers and effective cache, > increasing those made the performance worse. I've not looked at the rest of your problem in detail, but using the default configuration values is certainly not going to help things. In particular effective_cache is supposed to tell PG how much memory your OS is using to cache data. Read this through and make sure your configuration settings are sane, then it might be worthwhile looking in detail at this particular query. http://www.powerpostgresql.com/PerfList -- Richard Huxton Archonet Ltd