Re: [HACKERS] Binary search in fmgr_isbuiltin() is a bottleneck.

[tushar]

On 09/14/2017 12:21 PM, Andres Freund wrote:

Hi,

Surprising myself I discovered that in workloads that do a large number
of fmgr_info* lookups, fmgr_isbuiltin() is actually quite the
bottleneck.

After discussion with Jeevan Ladhe, we created a sql query which contain lots of inbuild function and tested that against pgbench    with  master v/s patch and found an improvement

pgbench -c 8 -j 8 -f /tmy/mytest.sql  -T 300 postgres


PG HEAD+patch -  tps =  5751.745767(8.32+% vs. head)


pgbench -c 8 -j 8 -f /tmp/mytest.sql   -T 500 postgres


PG HEAD+patch -  tps = 7953.934043(3.27+% vs. head)

--
regards,tushar
EnterpriseDB  https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

Virtual Machine configuration - Centos 6.5 x64 / 16 GB RAM / 8 VCPU core processor PG Head             -   tps = 5309.810807 (excluding connections establishing). PG Head             -  tps = 7701.176220(excluding connections establishing).

mytest.sql
Description: application/sql

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers