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

From Amit Langote
Subject Re: speeding up planning with partitions
Date
Msg-id ee0c1d07-e2bc-57af-6dd7-852eba7df61c@lab.ntt.co.jp
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
RE: speeding up planning with partitions
Re: speeding up planning with partitions
List pgsql-hackers
On 2019/03/05 9:50, Amit Langote wrote:
> I'll post the updated patches after diagnosing what
> I'm suspecting a memory over-allocation bug in one of the patches.  If you
> configure build with --enable-cassert, you'll see that throughput
> decreases as number of partitions run into many thousands, but it doesn't
> when asserts are turned off.

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,
Amit

Attachment

pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: Optimization of some jsonb functions
Next
From: Amit Langote
Date:
Subject: Re: speeding up planning with partitions