RE: ResourceOwner refactoring

Поиск
Список
Период
Сортировка
Искать
От
kuroda.hayato@fujitsu.com
Тема
RE: ResourceOwner refactoring
Дата
Msg-id
OSBPR01MB315778F8FDC6C4B55497D72FF5A10@OSBPR01MB3157.jpnprd01.prod.outlook.com
Ответ на
Re: ResourceOwner refactoring (Heikki Linnakangas)
Список
Дерево обсуждения
ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: ResourceOwner refactoring Michael Paquier <michael@paquier.xyz>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: ResourceOwner refactoring Michael Paquier <michael@paquier.xyz>
Re: ResourceOwner refactoring Julien Rouhaud <rjuju123@gmail.com>
Re: ResourceOwner refactoring Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
RE: ResourceOwner refactoring "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
RE: ResourceOwner refactoring "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
RE: ResourceOwner refactoring "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
RE: ResourceOwner refactoring "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
RE: ResourceOwner refactoring "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: ResourceOwner refactoring Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: ResourceOwner refactoring Robert Haas <robertmhaas@gmail.com>
Re: ResourceOwner refactoring Robert Haas <robertmhaas@gmail.com>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
RE: ResourceOwner refactoring "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: ResourceOwner refactoring Michael Paquier <michael@paquier.xyz>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: ResourceOwner refactoring Robert Haas <robertmhaas@gmail.com>
Re: ResourceOwner refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: ResourceOwner refactoring Michael Paquier <michael@paquier.xyz>
Re: ResourceOwner refactoring Michael Paquier <michael@paquier.xyz>
Re: ResourceOwner refactoring Craig Ringer <craig.ringer@enterprisedb.com>
Re: ResourceOwner refactoring Michael Paquier <michael@paquier.xyz>
Dear Heikki,

I tested in the same situation, and I confirmed that almost same results are returned.
(results are at the end of the e-mail)

You think that these results are acceptable
because resowners own many resources(more than 64) in general
and it's mainly faster in such a situation, isn't it?

I cannot distinguish correctly, but sounds good.

====test result====

unpatched

 numkeep | numsnaps | lifo_time_ns | fifo_time_ns 
---------+----------+--------------+--------------
       0 |        1 |         68.5 |         69.9
       0 |        5 |         73.2 |         76.8
       0 |       10 |         70.6 |         74.7
       0 |       60 |         68.0 |         75.6
       0 |       70 |         91.3 |         94.8
       0 |      100 |         89.0 |         89.1
       0 |     1000 |         97.9 |         98.9
       0 |    10000 |        116.0 |        115.9
       9 |       10 |         74.7 |         76.6
       9 |      100 |         80.8 |         80.1
       9 |     1000 |         86.0 |         86.2
       9 |    10000 |        116.1 |        116.8
      65 |       70 |         84.7 |         85.3
      65 |      100 |         80.5 |         80.3
      65 |     1000 |         86.3 |         86.2
      65 |    10000 |        115.4 |        115.9
(16 rows)

patched

 numkeep | numsnaps | lifo_time_ns | fifo_time_ns 
---------+----------+--------------+--------------
       0 |        1 |         62.4 |         62.6
       0 |        5 |         68.0 |         66.9
       0 |       10 |         73.6 |         78.1
       0 |       60 |         82.3 |         87.2
       0 |       70 |         83.0 |         89.1
       0 |      100 |         82.8 |         87.9
       0 |     1000 |         88.2 |         96.6
       0 |    10000 |        119.6 |        124.5
       9 |       10 |         62.0 |         62.8
       9 |      100 |         75.3 |         78.0
       9 |     1000 |         82.6 |         89.3
       9 |    10000 |        116.6 |        122.6
      65 |       70 |         66.7 |         66.4
      65 |      100 |         74.6 |         77.2
      65 |     1000 |         82.1 |         88.2
      65 |    10000 |        118.0 |        124.1
(16 rows)

Best Regards,
Hayato Kuroda
FUJITSU LIMITED

В списке pgsql-hackers по дате отправления
От: Craig Ringer
Дата:
От: tsunakawa.takay@fujitsu.com
Дата:
FAQ