Re: Optimize JsonbContainerTypeName by reordering type checks

Поиск
Список
Период
Сортировка
От Chao Li
Тема Re: Optimize JsonbContainerTypeName by reordering type checks
Дата
Msg-id CAEoWx2n25k=amT2u_KY+Dk-UmV8GZiHfx=qpmh0RC=PTbAO+nA@mail.gmail.com
обсуждение исходный текст
Ответ на Optimize JsonbContainerTypeName by reordering type checks  (Chao Li <li.evan.chao@gmail.com>)
Список pgsql-hackers
Hi Hacker,

This is an innocent refactor that doesn't change logic and improve performance of jsonb_typeof() a little bit.

I have done a performance test that proves a tiny performance improvement:

With the master branch:
```
% pgbench -n --no-vacuum -T 120 -c 8 -j 4 -f test_jsonb_type.sql evantest
tps = 83290.213196 (without initial connection time)

# second run
tps = 83709.266846 (without initial connection time)

# third run
tps = 83531.014990 (without initial connection time)
```

With this patch:
```
% pgbench -n --no-vacuum -T 120 -c 8 -j 4 -f test_jsonb_type.sql evantest
tps = 84172.324715 (without initial connection time)

# second run
tps = 84082.619469 (without initial connection time)

# third run
tps = 84260.671778 (without initial connection time)
```

With 3 runs average tps, this patch makes ~0.8% improvement for jsonb_typeof().

My test script is attached, it can run against any database. And attached v2 patch file has a tiny change over v1.

Best regards,
Chao Li (Evan)
---------------------
HighGo Software Co., Ltd.
https://www.highgo.com/
Вложения

В списке pgsql-hackers по дате отправления: