pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
To: Imai, Yoshikazu <imai.yoshikazu@jp.fujitsu.com>
To: 'Amit Langote' <amitlangote09@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Rowley <david.rowley@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Cc: Jesper Pedersen <jesper.pedersen@redhat.com>
Subject: Re: speeding up planning with partitions
Date: Wed, 20 Mar 2019 12:01:27 +0900
Message-ID: <72094fc9-3232-0fc7-b7cd-42e1c73d5aee@lab.ntt.co.jp> (raw)
In-Reply-To: <0F97FA9ABBDBE54F91744A9B37151A512B359C@g01jpexmbkw24>
References: <CAKJS1f9XAePd2+8F4=wtHKdDdckgKcSoXb-ZbU8Wbt86mhLxKA@mail.gmail.com>
	<0F97FA9ABBDBE54F91744A9B37151A51293422@g01jpexmbkw24>
	<8098beec-fc04-303d-55b9-73c3d94ba1ea@lab.ntt.co.jp>
	<b5362c29-cca1-de7b-13d0-9e51f9911185@lab.ntt.co.jp>
	<80afef3f-1870-5cb3-eeaf-7d8ecb41994c@lab.ntt.co.jp>
	<af3da198-e4aa-0535-8b13-40b02a4a7c41@lab.ntt.co.jp>
	<d768d90d-628e-6cdc-513d-f50a0ce02cea@redhat.com>
	<CA+HiwqFTqUVuiyK7dDQDCrNF1NiPDOAnmQum2jcw1yj5Z+kC0Q@mail.gmail.com>
	<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>
	<d964510e-2eec-ce42-8ad8-884caf718e03@lab.ntt.co.jp>
	<0F97FA9ABBDBE54F91744A9B37151A512B359C@g01jpexmbkw24>

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






view thread (265+ messages)  latest in thread

Message-ID: <72094fc9-3232-0fc7-b7cd-42e1c73d5aee@lab.ntt.co.jp>
Permalink:  ../72094fc9-3232-0fc7-b7cd-42e1c73d5aee@lab.ntt.co.jp/
Also on:    postgresql.org/message-id/72094fc9-3232-0fc7-b7cd-42e1c73d5aee@lab.ntt.co.jp

 · 

reply
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-hackers@postgresql.org
  Cc: Langote_Amit_f8@lab.ntt.co.jp, imai.yoshikazu@jp.fujitsu.com, amitlangote09@gmail.com, tgl@sss.pgh.pa.us, david.rowley@2ndquadrant.com, alvherre@2ndquadrant.com, robertmhaas@gmail.com, pryzby@telsasoft.com, jesper.pedersen@redhat.com
  Subject: Re: speeding up planning with partitions
  In-Reply-To: <72094fc9-3232-0fc7-b7cd-42e1c73d5aee@lab.ntt.co.jp>

* 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