Re: -HEAD planner issue wrt hash_joins on dbt3 ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: -HEAD planner issue wrt hash_joins on dbt3 ?
Date
Msg-id 27013.1158587479@sss.pgh.pa.us
Whole thread Raw
In response to Re: -HEAD planner issue wrt hash_joins on dbt3 ?  (Matteo Beccati <php@beccati.com>)
Responses Re: -HEAD planner issue wrt hash_joins on dbt3 ?  (Matteo Beccati <php@beccati.com>)
List pgsql-hackers
Matteo Beccati <php@beccati.com> writes:
> I cannot see anything bad by using something like that:
> if (histogram is large/representative enough)

Well, the question is exactly what is "large enough"?  I feel a bit
uncomfortable about applying the idea to a histogram with only 10
entries (especially if we ignore two of 'em).  With 100 or more,
it sounds all right.  What's the breakpoint?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Lukas Kahwe Smith
Date:
Subject: Re: [pgsql-www] Developer's Wiki
Next
From: Tom Lane
Date:
Subject: Re: guc comment changes (was Re: Getting a move on for 8.2 beta)