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
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 |