Re: query optimization Anyone know a better way to run this query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: query optimization Anyone know a better way to run this query
Дата
Msg-id 13025.1014343988@sss.pgh.pa.us
обсуждение исходный текст
Ответ на query optimization Anyone know a better way to run this query  ("David Blood" <david@matraex.com>)
Список pgsql-general
Дерево обсуждения 
"David Blood" <david@matraex.com> writes:
> Anyone know a better way to run this query to make it faster.

> SET ENABLE_SEQSCAN TO OFF;

Are you sure that's a good idea?  The plan looks to me like it would be
better off *without* indexscans.

How many rows are you expecting to get out of the join?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Follow Up: How to properly build postgresql version 7.2 on Unix Platforms?
Следующее
От: missive@frontiernet.net (Lee Harr)
Дата:
Сообщение: Re: Createdb problems