Re: Group-count estimation statistics - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Group-count estimation statistics
Date
Msg-id 22119.1107200408@sss.pgh.pa.us
Whole thread Raw
In response to Re: Group-count estimation statistics  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: Group-count estimation statistics
List pgsql-hackers
Manfred Koizar <mkoi-pg@aon.at> writes:
> That's not what I meant.  I tried to say that if we have a GROUP BY
> several columns and one of these columns alone has more than N/10
> distinct values, there's no way to get less than that many groups.

Oh, I see, you want a "max" calculation in there too.  Seems reasonable.
Any objections?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Bug in create operator and/or initdb
Next
From: "Merlin Moncure"
Date:
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command