Re: JDBC, prepared queries, and partitioning

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: JDBC, prepared queries, and partitioning
Дата
Msg-id 1202939756.16770.517.camel@ebony.site
обсуждение исходный текст
Ответ на Re: JDBC, prepared queries, and partitioning  ("Stephen Denne" <Stephen.Denne@datamail.co.nz>)
Ответы Re: JDBC, prepared queries, and partitioning  ("Stephen Denne" <Stephen.Denne@datamail.co.nz>)
Re: JDBC, prepared queries, and partitioning  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-jdbc
On Thu, 2008-02-14 at 10:45 +1300, Stephen Denne wrote:
> Simon Riggs wrote
> > ISTM we need a way to say "this query's parameters vary wildly at
> > execution time, so I really need to re-plan it every time".
>
> If the wild variations don't affect the cost estimate, they won't affect the plan?

Cost estimates are made at planning time. If you don't replan, no, they
won't.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: JDBC, prepared queries, and partitioning
Следующее
От: "Stephen Denne"
Дата:
Сообщение: Re: JDBC, prepared queries, and partitioning