agora inbox for pgsql-performance@postgresql.org  

help / color / mirror / Atom feed

From: Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
To: Antonio Batovanja <antonio.batovanja@humanomed.co.at>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query performance
Date: Wed, 31 May 2006 09:07:34 +0800
Message-ID: <447CEC56.3070106@calorieking.com> (raw)
In-Reply-To: <e4ucgu$n91$1@newsreader1.utanet.at>
References: <e4rvnb$o8f$1@newsreader1.utanet.at>
	<slrne74iif.jf9.sgunderson@trofast.sesse.net>
	<e4ucgu$n91$1@newsreader1.utanet.at>

> 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

view thread (48+ messages)  latest in thread

Message-ID: <447CEC56.3070106@calorieking.com>
Permalink:  ../447CEC56.3070106@calorieking.com/
Also on:    postgresql.org/message-id/447CEC56.3070106@calorieking.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: chris.kings-lynne@calorieking.com, antonio.batovanja@humanomed.co.at
  Subject: Re: Query performance
  In-Reply-To: <447CEC56.3070106@calorieking.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox