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 по дате отправления: