A caveat of partitioning tables in the document - Mailing list pgsql-hackers

From Kasahara Tatsuhito
Subject A caveat of partitioning tables in the document
Date
Msg-id CAP0=ZVLJkZfi3CwQ=DBU8YC_RM52hV6ZfVg-bXiJGzZaW1vKYA@mail.gmail.com
Whole thread Raw
Responses Re: A caveat of partitioning tables in the document
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: huge tlb support
Next
From: Robert Haas
Date:
Subject: Re: xlog file naming