Re: Query performance - Mailing list pgsql-performance

From Antonio Batovanja
Subject Re: Query performance
Date
Msg-id e4ucgu$n91$1@newsreader1.utanet.at
Whole thread Raw
In response to Re: Query performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Responses Re: Query performance  (Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Adding and filling new column on big table
Next
From: sibel karaasma
Date:
Subject: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!