Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment

Поиск
Список
Период
Сортировка
От Andrei Lepikhov
Тема Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
Дата
Msg-id 8e9f46ce-e087-4dd5-b0c2-4459170da11f@gmail.com
обсуждение исходный текст
Ответ на Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment  (Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>)
Ответы Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
Список pgsql-hackers
On 5/1/25 14:22, Ilia Evdokimov wrote:
>      Estimated Hit Percent: 50.00
> 
> Any suggestions?
I still think that two meaningful digits are enough for an EXPLAIN. We 
usually need to estimate the tuple set's size, not a precise number of 
tuples or groups. And definitely, not an arbitrarily chosen two digits 
after the point. So, IMO, good examples may look like the following:
50%, 5.0%, 0.00051%.

-- 
regards, Andrei Lepikhov



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