Alvaro Herrera wrote:
> Josh Berkus wrote:
> > Bruce, all:
> >
> > This is a longstanding performance issue which just came up again on IRC,
> > and I can't find a TODO item for it. So I'd like it added to TODO.
> > Suggested phrasing:
> >
> > -- Improve performance of queries with IN() claus
Tom,
> I think it's pretty much done. Try WHERE foo IN (VALUES (1),(2),...)
> if you have so many values that a non-nestloop join seems indicated.
Hmmm. Was there a reason not to automate this? Thread link is fine if
you can remember the subject line ... I can't find it on archives.
> The p
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Josh Berkus wrote:
>> -- Improve performance of queries with IN() clauses containing hundreds or
>> more literal values, possibly by re-writing it as a join to a virtual
>> table.
> Hmm, wasn't there some work on this regard in 8.2?
I think it's pret
Josh Berkus wrote:
> Bruce, all:
>
> This is a longstanding performance issue which just came up again on IRC,
> and I can't find a TODO item for it. So I'd like it added to TODO.
> Suggested phrasing:
>
> -- Improve performance of queries with IN() clauses containing hundreds or
> more lite
Bruce, all:
This is a longstanding performance issue which just came up again on IRC,
and I can't find a TODO item for it. So I'd like it added to TODO.
Suggested phrasing:
-- Improve performance of queries with IN() clauses containing hundreds or
more literal values, possibly by re-writing
