Re: [HACKERS] Binary search in fmgr_isbuiltin() is a bottleneck.
| От | tushar |
|---|---|
| Тема | Re: [HACKERS] Binary search in fmgr_isbuiltin() is a bottleneck. |
| Дата | |
| Msg-id | a23a4d7d-ad60-8ce1-948a-9c4458441241@enterprisedb.com обсуждение исходный текст |
| Ответ на | [HACKERS] Binary search in fmgr_isbuiltin() is a bottleneck. (Andres Freund <andres@anarazel.de>) |
| Ответы |
Re: [HACKERS] Binary search in fmgr_isbuiltin() is a bottleneck.
|
| Список | pgsql-hackers |
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 Virtual Machine configuration - Centos 6.5 x64 / 16 GB RAM / 8 VCPU core processor pgbench -c 8 -j 8 -f /tmy/mytest.sql -T 300 postgres PG Head - tps = 5309.810807 (excluding connections establishing). PG HEAD+patch - tps = 5751.745767(8.32+% vs. head) pgbench -c 8 -j 8 -f /tmp/mytest.sql -T 500 postgres PG Head - tps = 7701.176220(excluding connections establishing). PG HEAD+patch - tps = 7953.934043(3.27+% vs. head) -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Вложения
В списке pgsql-hackers по дате отправления: