Richard Huxton <dev@xxxxxxxxxxxx> writes: > Hmm - why is it doing that? I'm betting that the OP's people.uid column is not an integer. Existing PG releases can't use hashed subplans for cross-data-type comparisons (8.3 will be a bit smarter). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend