Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6RUD-0001iH-Tj for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 03:01:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6RUC-0005zO-DI for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 03:01:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6RUC-0005zH-5u for pgsql-hackers@lists.postgresql.org; Wed, 20 Mar 2019 03:01:48 +0000 Received: from tama500.ecl.ntt.co.jp ([129.60.39.148]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6RU8-0000xI-UV for pgsql-hackers@postgresql.org; Wed, 20 Mar 2019 03:01:47 +0000 Received: from vc2.ecl.ntt.co.jp (vc2.ecl.ntt.co.jp [129.60.86.154]) by tama500.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id x2K31eXN027976; Wed, 20 Mar 2019 12:01:40 +0900 Received: from vc2.ecl.ntt.co.jp (localhost [127.0.0.1]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id A7EFD6386DF; Wed, 20 Mar 2019 12:01:40 +0900 (JST) Received: from jcms-pop21.ecl.ntt.co.jp (jcms-pop21.ecl.ntt.co.jp [129.60.87.134]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id 9C39963868E; Wed, 20 Mar 2019 12:01:40 +0900 (JST) Received: from [127.0.0.1] (unknown [129.60.241.61]) by jcms-pop21.ecl.ntt.co.jp (Postfix) with ESMTPSA id 92F3B4007D2; Wed, 20 Mar 2019 12:01:40 +0900 (JST) Subject: Re: speeding up planning with partitions References: <0F97FA9ABBDBE54F91744A9B37151A51293422@g01jpexmbkw24> <8098beec-fc04-303d-55b9-73c3d94ba1ea@lab.ntt.co.jp> <80afef3f-1870-5cb3-eeaf-7d8ecb41994c@lab.ntt.co.jp> <0F97FA9ABBDBE54F91744A9B37151A5129DD55@g01jpexmbkw24> <256b9c87-b687-6f51-6274-19ae5743aef6@lab.ntt.co.jp> <0F97FA9ABBDBE54F91744A9B37151A5129E604@g01jpexmbkw24> <9feacaf6-ddb3-96dd-5b98-df5e927b1439@lab.ntt.co.jp> <0F97FA9ABBDBE54F91744A9B37151A512B3279@g01jpexmbkw24> <0c90ce90-b010-4791-41c0-a0df34f99ffa@lab.ntt.co.jp> <0F97FA9ABBDBE54F91744A9B37151A512B3528@g01jpexmbkw24> <0F97FA9ABBDBE54F91744A9B37151A512B359C@g01jpexmbkw24> From: Amit Langote Message-ID: <72094fc9-3232-0fc7-b7cd-42e1c73d5aee@lab.ntt.co.jp> Date: Wed, 20 Mar 2019 12:01:27 +0900 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.5.3 MIME-Version: 1.0 In-Reply-To: <0F97FA9ABBDBE54F91744A9B37151A512B359C@g01jpexmbkw24> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit X-CC-Mail-RelayStamp: 1 To: "Imai, Yoshikazu" , "'Amit Langote'" Cc: Tom Lane , David Rowley , Alvaro Herrera , Robert Haas , Justin Pryzby , Pg Hackers , Jesper Pedersen X-TM-AS-MML: disable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019/03/20 11:51, Imai, Yoshikazu wrote: > Amit-san, > > On Wed, Mar 20, 2019 at 2:34 AM, Amit Langote wrote: >> On 2019/03/20 11:21, Imai, Yoshikazu wrote: >>> (4) >>> We expect the performance does not depend on the number of partitions >> after applying all patches, if possible. >>> >>> num of part TPS >>> ----------- ----- >>> 1024 7,257 (7274, 7246, 7252) >>> 2048 6,718 (6627, 6780, 6747) >>> 4096 6,472 (6434, 6565, 6416) (quoted from above (3)'s results) >>> 8192 6,008 (6018, 5999, 6007) >>> >>> It seems the performance still depend on the number of partitions. At >> the moment, I don't have any idea what cause this problem but can we improve >> this more? >> >> I've noticed [1] this kind of degradation when the server is built with >> Asserts enabled. Did you? >> ... >> [1] >> https://www.postgresql.org/message-id/a49372b6-c044-4ac8-84ea-90ad18 >> b1770d%40lab.ntt.co.jp > > No. I did test again from configuring without --enable-cassert but problem I mentioned still happens. Hmm, OK. Can you describe your test setup with more details? Thanks, Amit