Re: proposal : cross-column stats

Поиск
Список
Период
Сортировка
От Nicolas Barbier
Тема Re: proposal : cross-column stats
Дата
Msg-id AANLkTimn293-Ab71nuMXyDsiJAbTwNxs_Sv64RO+Gh7h@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal : cross-column stats  (Florian Pflug <fgp@phlo.org>)
Ответы Re: proposal : cross-column stats  (tv@fuzzy.cz)
Re: proposal : cross-column stats  (Florian Pflug <fgp@phlo.org>)
Список pgsql-hackers
2010/12/24 Florian Pflug <fgp@phlo.org>:

> On Dec23, 2010, at 20:39 , Tomas Vondra wrote:
>
>>   I guess we could use the highest possible value (equal to the number
>>   of tuples) - according to wiki you need about 10 bits per element
>>   with 1% error, i.e. about 10MB of memory for each million of
>>   elements.
>
> Drat. I had expected these number to come out quite a bit lower than
> that, at least for a higher error target. But even with 10% false
> positive rate, it's still 4.5MB per 1e6 elements. Still too much to
> assume the filter will always fit into memory, I fear :-(

I have the impression that both of you are forgetting that there are 8
bits in a byte. 10 bits per element = 1.25MB per milion elements.

Nicolas


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

Предыдущее
От: Pavel Golub
Дата:
Сообщение: Re: Cannot compile Pg 9.0.2 with MinGW under Windows
Следующее
От: Shigeru HANADA
Дата:
Сообщение: Re: SQL/MED - core functionality