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

From Kevin Grittner
Subject Re: estimating # of distinct values
Date
Msg-id 4D18C3AF0200002500038BEF@gw.wicourts.gov
Whole thread Raw
In response to Re: estimating # of distinct values  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: estimating # of distinct values  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: estimating # of distinct values  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> With respect to (b), I think I'd need to see a much more detailed
> design for how you intend to make this work.  Off the top of my
> head there seems to be some pretty serious feasibility problems.
I had one random thought on that -- it seemed like a large concern
was that there would need to be at least an occasional scan of the
entire table to rebuild the distinct value information.  Don't we
already require an occasional scan of the entire table for freezing
transaction IDs?  Could this be part of any vacuum of the entire
table?
-Kevin


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: SSI memory mitigation & false positive degradation
Next
From: Tom Lane
Date:
Subject: Re: estimating # of distinct values