Mike Harding <mvh(at)ix(dot)netcom(dot)com> writes:
> Any way to adjust n_distinct to be more accurate?
You could try increasing the statistics target for the relevant columns.
What does pg_stats show for the "numdistinct" estimates of the columns
you are grouping over, and does that have anything to do with reality?
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2005-02-25 22:19:34|
|Subject: Re: Questions regarding notify processing. |
|Previous:||From: Mike Harding||Date: 2005-02-25 22:04:14|
|Subject: Re: Hash aggregates blowing out memory|