Re: estimating # of distinct values - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: estimating # of distinct values
Date
Msg-id E42C65A0-A7C3-4FE1-877F-555E1C7836F4@nasby.net
Whole thread Raw
In response to Re: estimating # of distinct values  (tv@fuzzy.cz)
Responses Re: estimating # of distinct values  (Tomas Vondra <tv@fuzzy.cz>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: system views for walsender activity
Next
From: Joel Jacobson
Date:
Subject: Re: obj_unique_identifier(oid)