Re: Planning large IN lists - Mailing list pgsql-hackers

From Lukas Kahwe Smith
Subject Re: Planning large IN lists
Date
Msg-id 464367A0.9010003@pooteeweet.org
Whole thread Raw
In response to Planning large IN lists  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Neil Conway wrote:

> Clearly, the current approach is fine when the array is small -- perhaps
> for arrays above a certain number of elements, we could switch to
> randomly sampling array elements, estimating their selectivities, and
> then using that information to infer the estimated selectivity of the
> entire array expression. That seems fairly crude, though: does anyone
> have any better ideas?

Optimizer hints in SQL
/me ducks and runs for cover.

regards,
Lukas


pgsql-hackers by date:

Previous
From: "CK Tan"
Date:
Subject: Re: Seq scans roadmap
Next
From: Tom Lane
Date:
Subject: Re: Planning large IN lists