"Axel Noltemeier" <[EMAIL PROTECTED]> writes: > -- This statement generates an unnecessary(?) lock > -- on factory_pkey. That index is not used in the plan. > EXPLAIN ANALYZE SELECT * > FROM factory f > Where f.id IN (select m.factory_id from machine m);
That behavior was changed here: http://archives.postgresql.org/pgsql-committers/2006-07/msg00356.php I'm disinclined to consider reverting that change... It's possible that we could modify the planner to release locks at the end of planning on indexes it chooses not to use, but 99.9% of the time it'd be a waste of cycles to do that. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
