There is one thing I really miss when working with PostgreSQL.
In many cases I have to optimize complex queries (8-10 tables, views and 
tables, ...).
I can define if indexes are used or not but it would be fine to turn 
indexes on certain tables off temporarily.

At OSCON Gavin Sherry has mentioned that it should not be hard to add 
this to PostgreSQL. I guess we'd need an internal list which sets the 
costs of an index to infinite in order to make it unused.

This would make many things so much easier and so much faster.
I agree with Tom when saying that improving the optimizer would be 
better but this would be an immediate, easy to achieve help for many 
people out there.

Could anybody implement that? I am not enough into Postgres internals to 
implement it myself.

	Regards,
		Hans


Mon, 05 Aug 2002 19:25:05 +0200
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <hs@cybertec.at>
Feature Request: Optimizer tuning