Chuck,
explain analyze SELECT country_id, country_name FROM geo.country WHERE country_id IN (select country_id FROM geo.city) ;-- won't complete in a reasonable amount of time.
Can we see the plan? --Josh ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster