Re: [HACKERS] A caveat of partitioning tables in the document

2012-08-27 Thread Kasahara Tatsuhito
2012/8/23 Tom Lane : > Fujii Masao writes: >> On Wed, Aug 22, 2012 at 12:59 AM, Kasahara Tatsuhito >> wrote: >>> The latest document (doc/src/sgml/ddl.sgml) says >>> === >>> 2974 >>> 2975 >>> 2976 >>> 2977 Constraint exclusion only works wh

Re: [HACKERS] A caveat of partitioning tables in the document

2012-08-22 Thread Tom Lane
Fujii Masao writes: > On Wed, Aug 22, 2012 at 12:59 AM, Kasahara Tatsuhito > wrote: >> The latest document (doc/src/sgml/ddl.sgml) says >> === >> 2974 >> 2975 >> 2976 >> 2977 Constraint exclusion only works when the query's WHERE >> 2978

Re: [HACKERS] A caveat of partitioning tables in the document

2012-08-22 Thread Fujii Masao
On Wed, Aug 22, 2012 at 12:59 AM, Kasahara Tatsuhito wrote: > Hi. > > The latest document (doc/src/sgml/ddl.sgml) says > === > 2974 > 2975 > 2976 > 2977 Constraint exclusion only works when the query's WHERE > 2978 clause contains cons

[HACKERS] A caveat of partitioning tables in the document

2012-08-21 Thread Kasahara Tatsuhito
Hi. The latest document (doc/src/sgml/ddl.sgml) says === 2974 2975 2976 2977 Constraint exclusion only works when the query's WHERE 2978 clause contains constants. A parameterized query will not be 2979 optimized, since the plan