Re: Query performance

From: Antonio Batovanja <antonio(dot)batovanja(at)humanomed(dot)co(dot)at>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2006-05-23 07:10:29
Message-ID: e4ucgu$n91$1@newsreader1.utanet.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Steinar H. Gunderson wrote:

> antonio(dot)batovanja(at)humanomed(dot)co(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tim Jones 2006-05-23 13:26:37 Re: slow query using sub select
Previous Message Jonathan Blitz 2006-05-23 00:33:09 Re: slow query using sub select