X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A5F099FA5F0 for ; Tue, 30 May 2006 22:36:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45145-09 for ; Tue, 30 May 2006 22:35:58 -0300 (ADT) X-Greylist: delayed 00:31:42.956827 by SQLgrey- Received: from houston.familyhealth.com.au (iihouston.familyhealth.com.au [203.59.102.239]) by postgresql.org (Postfix) with ESMTP id DD8709FA5E1 for ; Tue, 30 May 2006 22:35:58 -0300 (ADT) Received: from houston.familyhealth.com.au (localhost [127.0.0.1]) by houston.familyhealth.com.au (Postfix) with ESMTP id D0DF62573F; Wed, 31 May 2006 09:04:11 +0800 (WST) Received: from [127.0.0.1] (work-48.internal [192.168.0.48]) by houston.familyhealth.com.au (Postfix) with ESMTP id 4354C2573B; Wed, 31 May 2006 09:04:09 +0800 (WST) Message-ID: <447CEC56.3070106@calorieking.com> Date: Wed, 31 May 2006 09:07:34 +0800 From: Christopher Kings-Lynne User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Antonio Batovanja Cc: pgsql-performance@postgresql.org Subject: Re: Query performance References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-familyhealth-MailScanner-Information: Please contact the ISP for more information X-familyhealth-MailScanner: Found to be clean X-familyhealth-MailScanner-From: chris.kings-lynne@calorieking.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/560 X-Sequence-Number: 19347 > I'm executing the queries from phpPgAdmin. > The above are for explain analyse. I was referring to the pure query > execution time. > Does anyone have an idea why the OR-query takes so long? > Any server-side tuning possibilities? I wouldn't like to change the code of > ldap's back-sql... If you're using phpPgAdmin's timings, they could be more off than the real explain analyze timings. Make sure you're using the figure given by explain analyze itself. Chris