Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XCLJp-00057c-R5 for pgsql-performance@arkaria.postgresql.org; Wed, 30 Jul 2014 04:16:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XCLJp-0000FH-6W for pgsql-performance@arkaria.postgresql.org; Wed, 30 Jul 2014 04:16:49 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XCLJn-0000FA-UC for pgsql-performance@postgresql.org; Wed, 30 Jul 2014 04:16:48 +0000 Received: from mail-pa0-x233.google.com ([2607:f8b0:400e:c03::233]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XCLJk-0002wK-Qn for pgsql-performance@postgresql.org; Wed, 30 Jul 2014 04:16:45 +0000 Received: by mail-pa0-f51.google.com with SMTP id ey11so785171pad.38 for ; Tue, 29 Jul 2014 21:16:43 -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:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=BY17uGTCzGDlT2Lju1L1C6/1xCGbTL2ex3Lmcax1r+k=; b=X6jmo0hznPuc/7tC0ppzwjY/zqxTr9jENFAuh8BVFc3/tJ14sysi2x+3IUMwmmy5Zb 5pj5MOG3w3vi3egH9qRZK+/vhs9WTkOZHROLiuP8J/ktlkgCY3fJpF3gNqLTuFqMLWXZ CXtMeNth9NXmDJSzuMQ6ZeS4knfw1PAXXfC24xBEIXuHwCkJXlM2tQf+Cw+NQyVKFwP5 QknBDILRbbA3HamWfTD2qXogS9ckwwH0DX/6j8+1pHmeQ1HVB1kXV62Q569Ioh2hsmzJ /SeaQqstnK7iGByhmjDwA3jYlEInTqV/ee9UUC8ik/Rk/z1YRoxy6qD51oVmQv1dfhuw JrkQ== X-Received: by 10.66.252.134 with SMTP id zs6mr1652913pac.40.1406693802848; Tue, 29 Jul 2014 21:16:42 -0700 (PDT) Received: from [192.168.2.104] ([116.226.74.154]) by mx.google.com with ESMTPSA id ny7sm3372886pab.48.2014.07.29.21.16.40 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 29 Jul 2014 21:16:42 -0700 (PDT) From: Rural Hunter X-Google-Original-From: Rural Hunter Message-ID: <53D871A4.8000301@gmail.com> Date: Wed, 30 Jul 2014 12:16:36 +0800 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.0 MIME-Version: 1.0 To: "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> <53D7597E.2080209@gmail.com> In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.0 (--) 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 This was no error in the log of pgbouncer, but there is a sudden drop of request count when the problem happened: 2014-07-30 11:36:51.919 25369 LOG Stats: 2394 req/s, in 339478 b/s, out 1422425 b/s,query 3792 us 2014-07-30 11:37:51.919 25369 LOG Stats: 2207 req/s, in 314570 b/s, out 2291440 b/s,query 5344 us 2014-07-30 11:38:51.919 25369 LOG Stats: 2151 req/s, in 288565 b/s, out 1945795 b/s,query 10016 us [=========problem happens=========] 2014-07-30 11:39:51.919 25369 LOG Stats: 1061 req/s, in 140077 b/s, out 2652730 b/s,query 515753 us [=========pgbouncer restart=========] 2014-07-30 11:40:52.780 10640 LOG File descriptor limit: 65535 (H:65535), max_client_conn: 5500, max fds possible: 6560 2014-07-30 11:40:52.781 10640 LOG Stale pidfile, removing 2014-07-30 11:40:52.782 10642 LOG listening on 0.0.0.0:xxxx 2014-07-30 11:40:52.782 10642 WARNING Cannot listen on ::/xxxx: bind(): Address already in use 2014-07-30 11:40:52.782 10642 LOG listening on unix:/tmp/.s.PGSQL.xxxx 2014-07-30 11:40:52.782 10642 LOG process up: pgbouncer 1.5.4, libevent 1.4.13-stable (epoll), adns: libc-2.11 2014-07-30 11:41:52.781 10642 LOG Stats: 2309 req/s, in 331097 b/s, out 3806033 b/s,query 4671 us 2014-07-30 11:42:52.782 10642 LOG Stats: 2044 req/s, in 285153 b/s, out 2932543 b/s,query 4789 us 2014-07-30 11:43:52.782 10642 LOG Stats: 1969 req/s, in 282697 b/s, out 560439 b/s,query 4607 us 2014-07-30 11:44:52.782 10642 LOG Stats: 2551 req/s, in 351589 b/s, out 3223438 b/s,query 4364 us -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance