Re: BUG #3067: Unnecessary lock blocks reindex

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Axel Noltemeier" <axel(dot)noltemeier(at)gmx(dot)de> 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