From: Rural Hunter <ruralhunter@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Very slow planning performance on partition table
Date: Tue, 29 Jul 2014 08:10:35 +0800
Message-ID: <53D6E67B.1040003@gmail.com> (raw)
In-Reply-To: <CAMkU=1ydmpt9XRMxt0sPNnQsXEoF_c7bgp2kHxtDbPNGg5Vj5w@mail.gmail.com>
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>
<CAMkU=1ydmpt9XRMxt0sPNnQsXEoF_c7bgp2kHxtDbPNGg5Vj5w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">在 2014/7/29 1:29, Jeff Janes 写道:<br>
</div>
<blockquote
cite="mid:CAMkU=1ydmpt9XRMxt0sPNnQsXEoF_c7bgp2kHxtDbPNGg5Vj5w@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra"><br>
<div class="gmail_quote">
<div>If it were waiting on a pg_locks lock, the semop should
be coming from ProcSleep, not from <span
style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:13px">LWLockAcquire,
shouldn't it?</span></div>
<div><span
style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:13px"><br>
</span></div>
<div><font color="#000000" face="arial, sans-serif">I'm
guessing he has a lot of connections, and each
connection is locking each partition in shared mode in
rapid fire, generating spin-lock or cache-line
contention.</font></div>
<div><font color="#000000" face="arial, sans-serif"><br>
</font></div>
<div>Cheers,</div>
<div><br>
</div>
<div>Jeff</div>
</div>
</div>
</div>
</blockquote>
Yes. I have a lot of connections and they maybe coming together and
doing the same update statement without partition key on the
partition table.<br>
</body>
</html>
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, jeff.janes@gmail.com
Subject: Re: Very slow planning performance on partition table
In-Reply-To: <53D6E67B.1040003@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