Re: Understanding explains

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Understanding explains
Дата
Msg-id 20041012005749.G98867@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Understanding explains  (Rosser Schwarz <rosser.schwarz@gmail.com>)
Список pgsql-performance
On Mon, 11 Oct 2004, Rosser Schwarz wrote:

> In general, it's best to let the planner make the appropriate choice
> without any artificial constraints.

As someone suggested ran with Explain analyze.
With seqscan_off was better.
Ran a vacuum analyze this afternoon so the stats were up to date.
Although I will leave the setting as it's default for most of everything I
do, it seems that for some reason in this case it mases sense to turn it
off.

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: why my query is not using index??
Следующее
От: Gabriele Bartolini
Дата:
Сообщение: Re: Normal case or bad query plan?