Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types

Поиск
Список
Период
Сортировка
От Ilia Evdokimov
Тема Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types
Дата
Msg-id 4f51168a-3a3e-4bae-b2e9-ba7bb05c06f7@tantorlabs.com
обсуждение
Ответ на Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types  (Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>)
Список pgsql-hackers
Have you benchmarked this change except in first message in this thread?

While reviewing the patch more closely, I noticed 
that compute_distinct_stats() is only used for types where we have =, != 
but not <. In practice, most common scalar types go through 
compute_scalar_stats() instead.

That makes me wonder how often this optimization would actually trigger 
in real workloads. Since compute_scalar_stats() is the more common path, 
there's chance that the hash-table based improvement in 
compute_distinct_stats() may not provide a noticeable overall benefit.

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/




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