Re: Arrays and index scan - Mailing list pgsql-performance

From Tom Lane
Subject Re: Arrays and index scan
Date
Msg-id 1309.1146238504@sss.pgh.pa.us
Whole thread Raw
In response to Arrays and index scan  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-performance
Markus Schaber <schabi@logix-tt.com> writes:
> However, the query planner seems to refuse to make index scans even with
> 8.1:
> testdb=# EXPLAIN SELECT * from streets WHERE link_id = ANY(ARRAY[1,2,3]);

Yup, that was just done in HEAD a couple months ago.

            regards, tom lane

pgsql-performance by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Why so slow?
Next
From: Erik Myllymaki
Date:
Subject: hardare config question