> For example, IIRC when joining an integer column with a SERIAL column,
> you must expicitly cast it as an integer or the planner will not use
> the indexes, right? (This is a guess, as I remember reading something
> like this and thinking, "How in the world is someone supposed to
> figure that out, even with EXPLAIN?")
That's not true at all. Perhaps you're thinking about BIGSERIAL and
int8 indexes - something that's been addressed in 8.0.
Chris