Re: avoiding seqscan?

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: avoiding seqscan?
Дата
Msg-id 3F78346F.5060809@bigfoot.com
обсуждение исходный текст
Ответ на Re: avoiding seqscan?  (Palle Girgensohn <girgen@pingpong.net>)
Список pgsql-performance
Palle Girgensohn wrote:
> Will that make a difference? From what I've seen, it does not make much
> difference, but I have seen queries speed up when rewritten explicit
> joins. I guess it depends on other things, but is it really so that the
> explicit joins are bad somehow? Do you have any pointers to
> documentation about it, if so?
>
> Thanks,
> Palle


Are not absolutelly bad but sometimes that path that you choose is not
the optimal, in postgres 7.4 use the explicit join will be less
limitative for the planner.

Regards
Gaetano Mendola


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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: advice on raid controller
Следующее
От: Oleg Lebedev
Дата:
Сообщение: Re: TPC-R benchmarks