Re: slow IN() clause for many cases

From: "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: slow IN() clause for many cases
Date: 2005-10-11 18:13:01
Message-ID: auto-000577577778@umail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


>Please post an explain analyze on your query with a 20-30 item IN clause so
that we can see what plan is being generated.

It is bitmap-OR on multiple index(PK) lookups.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-10-11 18:28:02 Re: Spinlocks and CPU Architectures
Previous Message Dann Corbit 2005-10-11 18:09:32 Re: Spinlocks and CPU Architectures