A caveat of partitioning tables in the document

From: Kasahara Tatsuhito <kasahara(dot)tatsuhito(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: A caveat of partitioning tables in the document
Date: 2012-08-21 15:59:25
Message-ID: CAP0=ZVLJkZfi3CwQ=DBU8YC_RM52hV6ZfVg-bXiJGzZaW1vKYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-08-21 16:01:03 Re: xlog file naming
Previous Message Robert Haas 2012-08-21 15:56:58 Re: huge tlb support