Re: speeding up planning with partitions - Mailing list pgsql-hackers

From Jesper Pedersen
Subject Re: speeding up planning with partitions
Date
Msg-id dcda0c1b-6360-193d-9c94-0113b0b905a1@redhat.com
Whole thread Raw
In response to Re: speeding up planning with partitions  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: speeding up planning with partitions
List pgsql-hackers
On 3/5/19 5:24 AM, Amit Langote wrote:
> Attached an updated version.  This incorporates fixes for both Jesper's
> and Imai-san's review.  I haven't been able to pin down the bug (or
> whatever) that makes throughput go down as the partition count increases,
> when tested with a --enable-cassert build.
> 

Thanks !

I'm seeing the throughput going down as well, but are you sure it isn't 
just the extra calls of MemoryContextCheck you are seeing ? A flamegraph 
diff highlights that area -- sent offline.

A non cassert build shows the same profile for 64 and 1024 partitions.

Best regards,
  Jesper


pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Delay locking partitions during query execution
Next
From: Robert Haas
Date:
Subject: Re: Question about commit 11cf92f6e2e13c0a6e3f98be3e629e6bd90b74d5