Re: Very slow planning performance on partition table

<div class="moz-cite-prefix">It's the default value(partition): <br /> # grep exclusion postgresql.conf<br />
#constraint_exclusion= partition    # on, off, or partition<br /><br /> btw, I'm on postgresql 9.2.4<br /><br /> 在
2014/7/241:35, Douglas J Hunley 写道:<br /></div><blockquote
cite="mid:CALxYTP66Mi9-GZkLdP4RBf1goUn2WGmGp0ra_yE055zYB_PGpQ@mail.gmail.com"type="cite"><div dir="ltr"><div
class="gmail_extra"><br/><div class="gmail_quote">On Wed, Jul 23, 2014 at 6:21 AM, Rural Hunter <span dir="ltr"><<a
href="mailto:ruralhunter@gmail.com"moz-do-not-send="true" target="_blank">ruralhunter@gmail.com</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0             .8ex;border-left:1px #ccc
solid;padding-left:1ex">What'swrong and how can I improve the planning performance?</blockquote></div><br /> What is
constraintexclusion set to?<br /><br clear="all" /><div><br /></div> -- <br /><div dir="ltr">Douglas J Hunley (<a
href="mailto:doug.hunley@gmail.com"moz-do-not-send="true"
target="_blank">doug.hunley@gmail.com</a>)</div></div></div></blockquote><br/>