Re: Very slow planning performance on partition table

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: Douglas J Hunley <doug(dot)hunley(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Very slow planning performance on partition table
Date: 2014-07-24 01:30:12
Message-ID: 53D061A4.2030409@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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    # 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(at)mail(dot)gmail(dot)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(at)gmail(dot)com" target="_blank">ruralhunter(at)gmail(dot)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(dot)hunley(at)gmail(dot)com" target="_blank">doug(dot)hunley(at)gmail(dot)com</a>)</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.5 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2014-07-25 01:53:23 Re: Very slow planning performance on partition table
Previous Message Jorge Fernandez 2014-07-23 20:33:15 Re: Can't get a standby built

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2014-07-24 04:57:31 Re: High rate of transaction failure with the Serializable Isolation Level
Previous Message Reza Taheri 2014-07-24 01:18:05 High rate of transaction failure with the Serializable Isolation Level