Hi, Tomi N/A wrote:
> When the subselect returns a lot of results, pgsql really takes it's time.8.1.something
PostgreSQL 8.2 improved a lot for IN clauses with lots of values. I think it now performs as good as an equal join query.
Regards Markus ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster