Re: Optimising "in" queries - Mailing list pgsql-performance

From Russell Smith
Subject Re: Optimising "in" queries
Date
Msg-id 46CD3A64.9050302@pws.com.au
Whole thread Raw
In response to Re: Optimising "in" queries  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-performance
Russell Smith wrote:
>
> Filter: (sensor_id = ANY ('{1137,1138,1139,1140}'::integer[]))
>
> I've never seen this plan item except for when array's are involved.  I
> could be wrong.  I'd like to know how this is generated when you don't
> have an array.
>

I have just discovered that PG 8.2 will turn an IN clause into an array
search instead of an OR list.  Sorry all.

Regards

Russell Smith

pgsql-performance by date:

Previous
From: Russell Smith
Date:
Subject: Re: Optimising "in" queries
Next
From: "Merlin Moncure"
Date:
Subject: asynchronous commit feature