Re: Simple join optimized badly?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Simple join optimized badly?
Дата
Msg-id 20061010164534.GA11843@wolff.to
обсуждение исходный текст
Ответ на Re: Simple join optimized badly?  (Tobias Brox <tobias@nordicbet.com>)
Список pgsql-performance
On Mon, Oct 09, 2006 at 23:33:03 +0200,
  Tobias Brox <tobias@nordicbet.com> wrote:
>
> Just a comment from the side line; can't the rough "set
> enable_seqscan=off" be considered as sort of a hint anyway?  There have
> been situations where we've actually had to resort to such crud.

That only works for simple queries. To be generally useful, you want to
be able to hint how to handle each join being done in the query. The
current controlls affect all joins.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: long running transactions
Следующее
От: Tobias Brox
Дата:
Сообщение: Re: long running transactions