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

From Amit Langote
Subject Re: speeding up planning with partitions
Date
Msg-id 0bb0f410-bfbc-3ee5-946b-43e89e8cbd57@lab.ntt.co.jp
Whole thread Raw
In response to Re: speeding up planning with partitions  (Jesper Pedersen <jesper.pedersen@redhat.com>)
Responses RE: speeding up planning with partitions
Re: speeding up planning with partitions
List pgsql-hackers
Hi Jesper,

Thanks for the review.  I've made all of the changes per your comments in
my local repository.  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.

On 2019/03/05 1:20, Jesper Pedersen wrote:
> I'll run some tests using a hash partitioned setup.

Thanks.

Regards,
Amit



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: POC: converting Lists into arrays
Next
From: Shawn Debnath
Date:
Subject: Re: Refactoring the checkpointer's fsync request queue