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

On Fri, Feb 8, 2019 at 1:34 AM, I wrote:
> On Wed, Feb 6, 2019 at 2:04 AM, Tsunakawa, Takayuki wrote:
> > Can you compare the performance of auto and force_custom_plan again
> > with the attached patch?  It uses PGPROC's LOCALLOCK list instead of
> > the hash table.
> 
> Thanks for the patch, but it seems to have some problems.

I just missed compiling.

Performance degradation I saw before is improved! The results are below.

[v20 + faster-locallock-scan.patch]
auto:   9,069 TPS
custom: 9,015 TPS

[v20]
auto:   8,037 TPS
custom: 8,933 TPS

As David and I mentioned this patch should be discussed on another thread, so Tsunakawa-san, could you launch the
anotherthread please?
 

Thanks
--
Yoshikazu Imai