Re: Query performance

Поиск
Список
Период
Сортировка
От Antonio Batovanja
Тема Re: Query performance
Дата
Msg-id e4ucgu$n91$1@newsreader1.utanet.at
обсуждение исходный текст
Ответ на Re: Query performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Ответы Re: Query performance
Список 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 по дате отправления:

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Adding and filling new column on big table
Следующее
От: sibel karaasma
Дата:
Сообщение: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!