Re: JDBC, prepared queries, and partitioning

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: JDBC, prepared queries, and partitioning
Дата
Msg-id 24210.1202939438@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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>)
Список pgsql-jdbc
"Stephen Denne" <Stephen.Denne@datamail.co.nz> writes:
> Isn't it more a case of
> "even a minor variation in just one of this query's parameters can result in wildly different cost estimate,
> so I really need to re-plan it every time."

The $64 problem is not that; it is that certain optimizations will not
be applied, period, unless the planner is dealing with values known
at plan time.

            regards, tom lane

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

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