Re: Group-count estimation statistics

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Group-count estimation statistics
Date: 2005-01-31 19:35:25
Message-ID: 0n1tv0p0ufe7f75hgsnj3l5l2dblarim45@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 31 Jan 2005 11:20:31 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>Already done that way.
> if (relvarcount > 1)
> clamp *= 0.1;

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.

Servus
Manfred

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2005-01-31 19:35:58 Re: [BUGS] Bug in create operator and/or initdb
Previous Message Paul Vixie 2005-01-31 19:28:28 Re: [BUGS] Bug in create operator and/or initdb