pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rural Hunter <ruralhunter@gmail.com>
To: Douglas J Hunley <doug.hunley@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Very slow planning performance on partition table
Date: Thu, 24 Jul 2014 09:30:12 +0800
Message-ID: <53D061A4.2030409@gmail.com> (raw)
In-Reply-To: <CALxYTP66Mi9-GZkLdP4RBf1goUn2WGmGp0ra_yE055zYB_PGpQ@mail.gmail.com>
References: <53CFB6BC.4050606@gmail.com>
	<CALxYTP66Mi9-GZkLdP4RBf1goUn2WGmGp0ra_yE055zYB_PGpQ@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

<html>
  <head>
    <meta content="text/html; charset=gb18030" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">It's the default value(partition): <br>
      # grep exclusion postgresql.conf<br>
      #constraint_exclusion = partition�0�2�0�2�0�2 # on, off, or partition<br>
      <br>
      btw, I'm on postgresql 9.2.4<br>
      <br>
      在 2014/7/24 1: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">&lt;<a moz-do-not-send="true"
                href="mailto:ruralhunter@gmail.com" target="_blank">ruralhunter@gmail.com</a>&gt;</span>
            wrote:<br>
            <blockquote class="gmail_quote" style="margin:0 0 0
              .8ex;border-left:1px #ccc solid;padding-left:1ex">What's
              wrong and how can I improve the planning performance?</blockquote>
          </div>
          <br>
          What is constraint exclusion set to?<br>
          <br clear="all">
          <div><br>
          </div>
          -- <br>
          <div dir="ltr">Douglas J Hunley (<a moz-do-not-send="true"
              href="mailto:doug.hunley@gmail.com" target="_blank">doug.hunley@gmail.com</a>)</div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>




view thread (21+ messages)  latest in thread

Message-ID: <53D061A4.2030409@gmail.com>
Permalink:  ../53D061A4.2030409@gmail.com/
Also on:    postgresql.org/message-id/53D061A4.2030409@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ruralhunter@gmail.com, doug.hunley@gmail.com
  Subject: Re: Very slow planning performance on partition table
  In-Reply-To: <53D061A4.2030409@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox