Re: estimating # of distinct values

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: estimating # of distinct values
Дата
Msg-id E42C65A0-A7C3-4FE1-877F-555E1C7836F4@nasby.net
обсуждение исходный текст
Ответ на Re: estimating # of distinct values  (tv@fuzzy.cz)
Ответы Re: estimating # of distinct values  (Tomas Vondra <tv@fuzzy.cz>)
Список pgsql-hackers
On Jan 7, 2011, at 5:32 AM, tv@fuzzy.cz wrote:
> Another thing I'm not sure about is where to store those intermediate
> stats (used to get the current estimate, updated incrementally). I was
> thinking about pg_stats but I'm not sure it's the right place - depending
> on the algorithm, this may be a fet kilobytes up to several megabytes. And
> it's not needed except when updating it. Any ideas?

If you're using it essentially as a queue, maybe a resource fork makes sense?
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: system views for walsender activity
Следующее
От: Joel Jacobson
Дата:
Сообщение: Re: obj_unique_identifier(oid)