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 по дате отправления