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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
