Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Arrays and index scan
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Markus Schaber <schabi(at)logix-tt(dot)com>
- Cc: PostgreSQL Performance List <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Arrays and index scan
- Date: Fri, 28 Apr 2006 11:35:04 -0400
Markus Schaber <schabi(at)logix-tt(dot)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
- References:
- Arrays and index scan
- From: Markus Schaber
- Arrays and index scan
- Prev by Date: Re: Why so slow?
- Next by Date: hardare config question
- Previous by thread: Arrays and index scan
- Next by thread: hardare config question
- Indexes: