Re: join selectivity - Mailing list pgsql-hackers

From Tom Lane
Subject Re: join selectivity
Date
Msg-id 26930.1103223389@sss.pgh.pa.us
Whole thread Raw
In response to Re: join selectivity  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Responses Re: join selectivity
List pgsql-hackers
"Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk> writes:
> ... But in the case of <column> <op>
> <unknown constant>, if we're estimating the number of rows to return then
> that becomes harder

I didn't say it was easy ;-).  The existing selectivity functions can't
do better than a rough guess in such cases, and I don't expect you can
either.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Re: join selectivity
Next
From: Greg Stark
Date:
Subject: Re: join selectivity