Re: Nested loop performance

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Nested loop performance
Дата
Msg-id 20031216171625.A31260@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Nested loop performance  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: Nested loop performance  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-performance
On Tue, 16 Dec 2003, Nick Fankhauser wrote:

> Is there a more efficient means than a nested loop to handle such a join?
> Would a different method be chosen if there was exactly one row in
> actor_summary for every row in actor?

As a question, what does explain analyze give you if you
set enable_nestloop=false; before trying the query?

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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Optimizing FK & PK performance...
Следующее
От: David Shadovitz
Дата:
Сообщение: Why is restored database faster?