Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XA7rU-0004xA-4t for pgsql-performance@arkaria.postgresql.org; Thu, 24 Jul 2014 01:30:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XA7rT-0007nE-Gm for pgsql-performance@arkaria.postgresql.org; Thu, 24 Jul 2014 01:30:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XA7rS-0007mO-Ku for pgsql-performance@postgresql.org; Thu, 24 Jul 2014 01:30:22 +0000 Received: from mail-pd0-x232.google.com ([2607:f8b0:400e:c02::232]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XA7rO-00057z-Ti for pgsql-performance@postgresql.org; Thu, 24 Jul 2014 01:30:21 +0000 Received: by mail-pd0-f178.google.com with SMTP id w10so2634480pde.37 for ; Wed, 23 Jul 2014 18:30:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:message-id:date:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=LTV0F56asOoh9qWtFi8U9zUlVQL7nBV7dlu5rx3Nuxw=; b=jlbOJV4GASoVK2rnXmh+myyjdtKBeRi73SngeON+Sq/q8HVe8K4aDbWmxWQHAE4V0U au35ta238dMYxFftmFLPckzrojWh2lmL0peglrTrRkR7veo3UNHwO6iCWRCpb+2TcQHY 1YTKeCs+SOO8uA5UqjaRM9mBgkz8u5eLcAX4QRK+4z7Sy/OfVqW6rsN49o/5LKjKDKiu jHanehedoYcXHD1IQZGUdd7FLquoGWBTYHVm+t6Gop8Fz2AKJ/xYy4TKS9yXUYzFTdOn KfexqWjPsqm4EIyk6HsGiGcBPH7YfaFzxmTf/PpEhIuMBEI9X5kclWaODQfh9Qveqrf7 mxEA== X-Received: by 10.66.136.14 with SMTP id pw14mr6522095pab.140.1406165415595; Wed, 23 Jul 2014 18:30:15 -0700 (PDT) Received: from [192.168.2.106] ([116.226.65.195]) by mx.google.com with ESMTPSA id rb8sm14558707pab.27.2014.07.23.18.30.13 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 23 Jul 2014 18:30:14 -0700 (PDT) From: Rural Hunter X-Google-Original-From: Rural Hunter Message-ID: <53D061A4.2030409@gmail.com> Date: Thu, 24 Jul 2014 09:30:12 +0800 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.0 MIME-Version: 1.0 To: Douglas J Hunley CC: pgsql-performance@postgresql.org Subject: Re: Very slow planning performance on partition table References: <53CFB6BC.4050606@gmail.com> In-Reply-To: Content-Type: text/html; charset=gb18030 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org

It's the default value(partition):
# grep exclusion postgresql.conf
#constraint_exclusion = partition # on, off, or partition

btw, I'm on postgresql 9.2.4

在 2014/7/24 1:35, Douglas J Hunley 写道:

On Wed, Jul 23, 2014 at 6:21 AM, Rural Hunter <ruralhunter@gmail.com> wrote:

What's wrong and how can I improve the planning performance?

What is constraint exclusion set to?

--

Douglas J Hunley (doug.hunley@gmail.com)