Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> If, say, your stats say there's 2B rows in the table but there's
> actually 2.5B, that's a big error, but unlikely to change the
> types of plans you get. Once there's millions of distinct values
> it's takes a big change for plans to shift, etc.
Well, the exception to that is if the stats say that your highest
value is x, and there are actually 500 million rows with values
greater than x, you can get some very bad plans for queries
requiring a range of values above x.
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2009-12-30 17:05:00|
|Subject: Re: KNNGiST for knn-search (WIP)|
|Previous:||From: Tom Lane||Date: 2009-12-30 16:56:31|
|Subject: Re: Thoughts on statistics for continuously advancing columns |