Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52036=pgsql-performance-ar@postgresql.org>)
 id 1XECcB-0005Yb-4X
 for pgsql-performance@arkaria.postgresql.org; Mon, 04 Aug 2014 07:23:27 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52036=pgsql-performance-ar@postgresql.org>)
 id 1XECc9-0008Mo-JW
 for pgsql-performance@arkaria.postgresql.org; Mon, 04 Aug 2014 07:23:25 +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 <ruralhunter@gmail.com>)
 id 1XECc7-0008MZ-Ey
 for pgsql-performance@postgresql.org; Mon, 04 Aug 2014 07:23:23 +0000
Received: from mail-pd0-x22f.google.com ([2607:f8b0:400e:c02::22f])
 by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <ruralhunter@gmail.com>)
 id 1XECc2-0005jK-Ei
 for pgsql-performance@postgresql.org; Mon, 04 Aug 2014 07:23:22 +0000
Received: by mail-pd0-f175.google.com with SMTP id r10so9097898pdi.6
 for <pgsql-performance@postgresql.org>; Mon, 04 Aug 2014 00:23:14 -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=aVIT1IFWeXSVhRaJULLnY24il8XTSGrR0tbiu3c5UzU=;
 b=ubavi7m5a16IZSqUzGHuwt+uO+TQXc1GaWzb5AAZXJC7SVpbXs+daeZb3H+OjpCmKp
 zoXqIAqT9/V/v/WPM2EotfuxH9RReSy195+pjaIRp30VBcjKwM/LIM7HMPHeOeLQbgUC
 3yepO4CZuWtn2OWsHcrDfYie/0i8KT2ZE6Wzsbq/IiiqGbI141F40rU1T3MQOBwMYwMA
 DL4Vqk02l1LmE/1NvT4dWI1ePcE6GuNqmVmo3z1nvq8fe9jC922vi9xEjsQ8MSBIySqF
 EEior+5lkoEsEJX0hJLqj9RVzQuZIwZt40Qon8vaVXPt57TGxfd54ooxIbOgyQBiovAM
 xWfg==
X-Received: by 10.68.88.161 with SMTP id bh1mr22265110pbb.6.1407136994633;
 Mon, 04 Aug 2014 00:23:14 -0700 (PDT)
Received: from [192.168.2.103] ([116.226.74.154])
 by mx.google.com with ESMTPSA id co14sm60252859pac.43.2014.08.04.00.23.12
 for <multiple recipients>
 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
 Mon, 04 Aug 2014 00:23:13 -0700 (PDT)
From: Rural Hunter <ruralhunter@gmail.com>
X-Google-Original-From: Rural Hunter <RuralHunter@gmail.com>
Message-ID: <53DF34DF.6010200@gmail.com>
Date: Mon, 04 Aug 2014 15:23:11 +0800
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.0
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Very slow planning performance on partition table
References: <53CFB6BC.4050606@gmail.com> <25010.1406253203@sss.pgh.pa.us>
 <53D26875.2080604@gmail.com> <53D51E49.102@gmail.com>
 <24564.1406478487@sss.pgh.pa.us>
In-Reply-To: <24564.1406478487@sss.pgh.pa.us>
Content-Type: text/plain; charset=gb18030; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.9 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi Tom,

Could my problem be a victim of this issue?
http://postgresql.1045698.n5.nabble.com/Planner-performance-extremely-affected-by-an-hanging-transaction-20-30-times-td5771686.html

is the patch mentioned in that thread applied in 9.2.9?


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance