Re: estimating # of distinct values

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: estimating # of distinct values
Date: 2011-01-07 22:34:59
Message-ID: 4D279513.8050506@fuzzy.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dne 7.1.2011 20:56, Jim Nasby napsal(a):
> On Jan 7, 2011, at 5:32 AM, tv(at)fuzzy(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-01-07 22:56:16 Re: LOCK for non-tables
Previous Message Florian Pflug 2011-01-07 22:17:18 Re: LOCK for non-tables