A caveat of partitioning tables in the document

Поиск
Список
Период
Сортировка
От Kasahara Tatsuhito
Тема A caveat of partitioning tables in the document
Дата
Msg-id CAP0=ZVLJkZfi3CwQ=DBU8YC_RM52hV6ZfVg-bXiJGzZaW1vKYA@mail.gmail.com
обсуждение исходный текст
Ответы Re: A caveat of partitioning tables in the document
Список pgsql-hackers
Hi.

The latest document (doc/src/sgml/ddl.sgml) says
=======================================
2974    <itemizedlist>
2975     <listitem>
2976      <para>
2977       Constraint exclusion only works when the query's <literal>WHERE</>
2978       clause contains constants.  A parameterized query will not be
2979       optimized, since the planner cannot know which partitions the
2980       parameter value might select at run time.  For the same reason,
2981       <quote>stable</> functions such as <function>CURRENT_DATE</function>
2982       must be avoided.
2983      </para>
2984     </listitem
=======================================
but in my understanding, this problem will be solved on 9.2 (with
parameterized plans).

Or some issues still remain ?

Best regards,

-- 
Tatsuhito Kasahara
kasahara.tatsuhito _at_ gmail.com



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: huge tlb support
Следующее
От: Robert Haas
Дата:
Сообщение: Re: xlog file naming