agora inbox for pgsql-performance@postgresql.org  

help / color / mirror / Atom feed

From: Antonio Batovanja <antonio.batovanja@humanomed.co.at>
To: pgsql-performance@postgresql.org
Subject: Re: Query performance
Date: Tue, 23 May 2006 09:10:29 +0200
Message-ID: <e4ucgu$n91$1@newsreader1.utanet.at> (raw)
References: <e4rvnb$o8f$1@newsreader1.utanet.at>
	<slrne74iif.jf9.sgunderson@trofast.sesse.net>

Steinar H. Gunderson wrote:

> antonio.batovanja@humanomed.co.at wrote:
>> The above query takes 5 seconds to execute!
>> 
>> [...]
>>
>>  Total runtime: 96109.571 ms
> 
> It sure doesn't look like it...
> 
>>  Total runtime: 461.907 ms
>>
>> [...]
>>
>> Suddenly the query takes only 0.29 seconds!
> 
> How are you timing this, really?
> 
> /* Steinar */

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...

Toni

view thread (48+ messages)  latest in thread

Message-ID: <e4ucgu$n91$1@newsreader1.utanet.at>
Permalink:  ../e4ucgu$n91$1@newsreader1.utanet.at/
Also on:    postgresql.org/message-id/e4ucgu$n91$1@newsreader1.utanet.at

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: antonio.batovanja@humanomed.co.at
  Subject: Re: Query performance
  In-Reply-To: <e4ucgu$n91$1@newsreader1.utanet.at>

* 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