Re: Planning large IN lists

From: Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>
To: Neil Conway <neilc(at)samurai(dot)com>
Subject: Re: Planning large IN lists
Date: 2007-05-10 18:42:40
Message-ID: 464367A0.9010003@pooteeweet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-05-10 18:53:28 Re: Planning large IN lists
Previous Message CK Tan 2007-05-10 18:27:00 Re: Seq scans roadmap