RE: Global shared meta cache

Поиск
Список
Период
Сортировка
Искать
От
Tsunakawa, Takayuki
Тема
RE: Global shared meta cache
Дата
Msg-id
0A3221C70F24FB45833433255569204D1FA25E63@G01JPEXMBYT05
Ответ на
Global shared meta cache (Ideriha, Takeshi)
Список
Дерево обсуждения
Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
RE: Global shared meta cache "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Global shared meta cache AJG <ayden@gera.co.nz>
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
RE: Global shared meta cache serge@rielau.com
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
Re: Global shared meta cache Andres Freund <andres@anarazel.de>
Re: Global shared meta cache Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
Re: Global shared meta cache Robert Haas <robertmhaas@gmail.com>
Re: Global shared meta cache Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: Global shared meta cache Andres Freund <andres@anarazel.de>
Re: Global shared meta cache Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
Re: Global shared meta cache Michael Paquier <michael@paquier.xyz>
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
RE: Global shared meta cache "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
Re: Global shared meta cache Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: Global shared meta cache Alvaro Herrera <alvherre@2ndquadrant.com>
RE: Global shared meta cache "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
RE: Global shared meta cache "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
RE: Global shared meta cache "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
Re: Global shared meta cache Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: Global shared meta cache "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
Re: Global shared meta cache Michael Paquier <michael@paquier.xyz>
Re: Global shared meta cache Tomas Vondra <tomas.vondra@2ndquadrant.com>
RE: Global shared meta cache "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com> 
From: Ideriha, Takeshi [mailto:ideriha.takeshi@jp.fujitsu.com]
> 1) Initialized with pgbench -i -s10
...
>    pgbench -c48 -T60 -Msimple      | 4956   	   |4965
> |95%

The scaling factor should be much greater than the number of clients.  Otherwise, multiple clients would conflict on the same row of branches table, which might hide the additional overhead of the global metacache.

And I think -j should be 12 or so on your 16-core server, so that the pgbench client can maximize its concurrency.


Regards
Takayuki Tsunakawa
В списке pgsql-hackers по дате отправления
Предыдущее
От: Charles Cui
Дата:
Следующее
От: Andrey V. Lepikhov
Дата:
FAQ