Re: index vs. seq scan choice?

Поиск
Список
Период
Сортировка
От George Pavlov
Тема Re: index vs. seq scan choice?
Дата
Msg-id 8C5B026B51B6854CBE88121DBF097A86DEA6C5@ehost010-33.exch010.intermedia.net
обсуждение исходный текст
Ответ на Re: index vs. seq scan choice?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: index vs. seq scan choice?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: index vs. seq scan choice?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> From: Joshua D. Drake [mailto:jd@commandprompt.com]
>
> In those rare cases wouldn't it make more sense to just set
> enable_seqscan to off; run query; set enable_seqscan to on;

1. these cases are not that rare (to me);

2. setting enable_seqscan (in JDBC, say) from the application makes the
whole thing quite a mess (need to do a batch of statements: each query
wrapped in its enable/disable seq scan?) -- ideally, one would like to
issue mostly SQL statements, not config parameters from the application;

3. if this is the recommended suggestion on how to run queries then why
don't we just add HINTS to the system and be done with it...




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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: index vs. seq scan choice?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: index vs. seq scan choice?