RE: Protect syscache from bloating with negative cache entries

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: Protect syscache from bloating with negative cache entries
Дата
Msg-id 0A3221C70F24FB45833433255569204D1FB9DEA3@G01JPEXMBYT05
обсуждение исходный текст
Ответ на RE: Protect syscache from bloating with negative cache entries  ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
Ответы RE: Protect syscache from bloating with negative cache entries  ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
Список pgsql-hackers
From: Ideriha, Takeshi [mailto:ideriha.takeshi@jp.fujitsu.com]
> number of tables   | 100  |1000    |10000
> -----------------------------------------------------------
> TPS (master)       |10966  |10654 |9099
> TPS (patch)        | 11137 (+1%) |10710 (+0%) |772 (-91%)
> 
> It seems that before cache exceeding the limit (no pruning at 100 and 1000),
> the results are almost same with master but after exceeding the limit (at
> 10000)
> the decline happens.

How many concurrent clients?

Can you show the perf's call graph sampling profiles of both the unpatched and patched version, to confirm that the
bottleneckis around catcache eviction and refill?
 


Regards
Takayuki Tsunakawa



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

Предыдущее
От: RSR999GMAILCOM
Дата:
Сообщение: Using old master as new replica after clean switchover
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Prepared transaction releasing locks before deregistering its GID