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

From Tomas Vondra
Subject Re: estimating # of distinct values
Date
Msg-id 4D279513.8050506@fuzzy.cz
Whole thread Raw
In response to Re: estimating # of distinct values  (Jim Nasby <jim@nasby.net>)
Responses Re: estimating # of distinct values  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
Dne 7.1.2011 20:56, Jim Nasby napsal(a):
> 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?

A resource fork? Not sure what you mean, could you describe it in more
detail?

regards
Tomas


pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: LOCK for non-tables
Next
From: Zotov
Date:
Subject: Re: join functions