Re: Have I b0rked something? Slow comparisons on "where x in (...)"

Listmail wrote:
>
>     Followup to my previous test, with an index this time
>
> EXPLAIN ANALYZE SELECT * FROM test WHERE value IN ( 1000 integers )

I'm not quite sure what you're trying to measure here, but I don't think
it is what was suggested.

IIRC the suggestion was to move the values from your IN (...) operator
into a temp table and join against that.

Try measuring something like this:

EXPLAIN ANALYZE SELECT * FROM table JOIN test ON (table.column = test.value)

vs.

EXPLAIN ANALYZE SELECT * FROM table WHERE value IN ( 1000 integers )

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //