Re: Guesses on what this NestLoop is for?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Guesses on what this NestLoop is for?
Дата
Msg-id 200310280936.02167.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Guesses on what this NestLoop is for?  (Manfred Koizar <mkoi-pg@aon.at>)
Список pgsql-performance
Manfred,

> Sorry, I have no answer to your question, but may I ask whether you
> really want to get presumably 106 output rows for each event with
> status 1?
>
> Or did you mean
>      WHERE (events.status = 1 OR events.status = 11) AND ...

Thanks!   I spent so much time tinkering around with the exists clauses, I
completely missed that.   Hopefully I'll get this client to upgrade to 7.4 so
that the explains will be more readable ....

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Jeff
Дата:
Сообщение: Re: Adding foreign key performance
Следующее
От: markw@osdl.org
Дата:
Сообщение: Re: analyzing postgresql performance for dbt-2