RE: minimizing pg_stat_statements performance overhead

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема RE: minimizing pg_stat_statements performance overhead
Дата
Msg-id alpine.DEB.2.21.1903280704380.4274@lancre
обсуждение исходный текст
Ответ на RE: minimizing pg_stat_statements performance overhead  (Raymond Martin <ramarti@microsoft.com>)
Ответы RE: minimizing pg_stat_statements performance overhead
Список pgsql-hackers
Hello Raymond,

>> Note that this does not mean that the patch should not be applied, it 
>> looks like an oversight, but really I do not have the performance 
>> degradation you are suggesting.
>
> I appreciate your input and I want to come up with a canonical test that 
> makes this contention more obvious. Unfortunately, it is difficult 
> because the criteria that causes this slow down (large query sizes and 
> distinct non-repeated queries) are difficult to reproduce with pgbench. 
> I would be open to any suggestions here.
>
> So even though the performance gains in this specific scenario are not 
> as great, do you still think it would make sense to submit a patch like 
> this?

Sure, it definitely makes sense to reduce the overhead when the extension 
is disabled. I wanted to understand the source of performance issue, and 
your explanations where not enough for reproducing it.

-- 
Fabien.



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

Предыдущее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: RE: Timeout parameters
Следующее
От: Haribabu Kommi
Дата:
Сообщение: Re: Transaction commits VS Transaction commits (with parallel) VSquery mean time