Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XBewB-0002qj-1T for pgsql-performance@arkaria.postgresql.org; Mon, 28 Jul 2014 07:01:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XBew9-0003EZ-9X for pgsql-performance@arkaria.postgresql.org; Mon, 28 Jul 2014 07:01:33 +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 1XBew7-0003ES-Uv for pgsql-performance@postgresql.org; Mon, 28 Jul 2014 07:01:32 +0000 Received: from mail-pd0-x22f.google.com ([2607:f8b0:400e:c02::22f]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XBew4-0001WD-O8 for pgsql-performance@postgresql.org; Mon, 28 Jul 2014 07:01:29 +0000 Received: by mail-pd0-f175.google.com with SMTP id r10so9308222pdi.6 for ; Mon, 28 Jul 2014 00:01:26 -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=NlXrrEIsdcHvKzZfmEf0NspxT/VdXyiOF401+ya5Of8=; b=DjPPniKuwOWIQNQXw4tboPGAag/F1JbILFqTJ9h5Z7nDD/xl6VCZhAXprqdpkwy1S/ 3MPid0xaUpLpPwLmHDvlaOT1vZ4h8Rg7yFObe/sbDm5znK7uJkZrXRFr+em65F3U6+ph StieASEXesD5MDwm2VithAR2ZavsYeZMcapCipdZMaiZVKJuYpIGR6uioiBZ7zGU26XO LoZig4FTzj2otHeJ7dUFYRpMvCY9SGiAJPajfCXju67IsJDhdKeYpnIkSU1wxWceew8A 9mTXafhQulaDRPu2Wuw74/oFbmGpRJhJQI3rvdBOrwL9TubVV4VhffRCYFKhQYi0YZJi KsTA== X-Received: by 10.70.91.73 with SMTP id cc9mr1552585pdb.138.1406530886827; Mon, 28 Jul 2014 00:01:26 -0700 (PDT) Received: from [192.168.2.106] ([116.226.74.154]) by mx.google.com with ESMTPSA id fo2sm16580700pbb.53.2014.07.28.00.01.22 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 28 Jul 2014 00:01:26 -0700 (PDT) From: Rural Hunter X-Google-Original-From: Rural Hunter Message-ID: <53D5F53F.7080701@gmail.com> Date: Mon, 28 Jul 2014 15:01:19 +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> <53D5A503.5060406@gmail.com> In-Reply-To: <53D5A503.5060406@gmail.com> Content-Type: text/plain; charset=gb18030; 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 is the vmstat output when the high load peak happens: # vmstat 3 procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 54 1 756868 1047128 264572 341573472 0 0 243 272 1 2 51 7 39 2 53 1 756888 924452 264508 341566080 0 7 31379 3623 53110 184808 29 55 15 1 70 1 756892 992416 264408 341530880 0 3 14483 9455 53010 183758 23 61 15 1 93 1 756900 954704 264160 341514208 0 3 20280 3391 66607 304526 23 59 17 1 65 2 756916 998524 263696 341427520 0 5 23295 2084 53748 213259 26 60 12 1 46 0 756924 969036 263636 341421088 0 3 23508 1447 51134 200739 22 59 19 1 123 1 756932 977336 263568 341426016 0 3 21444 2747 48044 174390 27 59 13 1 71 2 756932 975932 263580 341483520 0 0 19328 89629 54321 234718 25 59 14 2 47 5 756932 967004 263676 341502240 0 0 19509 52652 56792 236648 21 60 15 4 70 0 756944 1038464 263660 341468800 0 4 21349 3584 51937 179806 25 59 15 1 70 0 756940 923800 263532 341475712 0 0 15135 1524 58201 236794 21 59 19 1 40 1 756940 1022420 263560 341506560 0 0 9163 4889 34702 130106 19 61 19 1 59 0 756944 939380 263500 341518144 0 1 22809 4024 46398 224644 21 60 19 1 56 1 756956 954656 263464 341469440 0 4 22927 4477 53705 175386 28 57 14 1 39 0 756976 968204 263372 341376576 0 7 24612 2556 61900 262784 30 51 18 1 109 1 756984 1015260 263332 341323776 0 3 16636 4039 29271 83699 7 85 7 1 76 6 756992 980044 263312 341308128 0 3 6949 1848 27496 130478 6 90 2 2 103 0 756992 963540 263308 341352064 0 0 22125 2493 20526 61133 4 88 6 2 Seems most of the cpu is used by sys part. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance