Re: Query performance

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Query performance
Дата
Msg-id 447CEC56.3070106@calorieking.com
обсуждение исходный текст
Ответ на Re: Query performance  (Antonio Batovanja <antonio.batovanja@humanomed.co.at>)
Список pgsql-performance
> 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Bulk loading/merging
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why the 8.1 plan is worst than 7.4?