Re: Optimizing ResouceOwner to speed up COPY

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Optimizing ResouceOwner to speed up COPY
Дата
Msg-id f4b60fe5-5c58-4a9a-a9e0-eb6e16323422@vondra.me
обсуждение исходный текст
Ответ на Re: Optimizing ResouceOwner to speed up COPY  (Tomas Vondra <tomas@vondra.me>)
Ответы Re: Optimizing ResouceOwner to speed up COPY
Список pgsql-hackers
On 10/21/25 16:43, Tomas Vondra wrote:
> ...
> 
> The results seem fairly stable, and the overall trend is clear. It'd be
> great if there were no regressions, but considering how narrow is this
> microbenchmark (and considering the benefits for practical COPY runs),
> I'd say it's probably OK.
> 

The regression for non-pathological cases (like COPY) is bothering me,
even if it's a very narrow microbenchmark and I'd bet it would not be
measurable in practice. Still, it's annoying.

I wonder if maybe a better solution would be to invent a concept of
tuple slots for the same descriptor, and allow it to be tracked only
once in the resource owner. That'd mean no duplicates, completely
eliminating the pathological case.


regards

-- 
Tomas Vondra




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