Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

2005-05-04 Thread John A Meinel
Josh Berkus wrote: Mischa, Okay, although given the track record of page-based sampling for n-distinct, it's a bit like looking for your keys under the streetlight, rather than in the alley where you dropped them :-) Bad analogy, but funny. The issue with page-based vs. pure random sampling is th

Re: [HACKERS] Recognizing range constraints (was Re: [PERFORM] Plan

2005-04-10 Thread John A Meinel
Tom Lane wrote: "Jim C. Nasby" <[EMAIL PROTECTED]> writes: On Wed, Apr 06, 2005 at 06:09:37PM -0400, Tom Lane wrote: Can anyone suggest a more general rule? Do we need for example to consider whether the relation membership is the same in two clauses that might be opposite sides of a range restric