Re: SQL Performance Guidelines

> 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