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