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 another thread please? Thanks -- Yoshikazu Imai
