Feature Request: Optimizer tuning

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Feature Request: Optimizer tuning
Date: 2002-08-05 17:25:05
Message-ID: aimcab$2irc$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-08-05 17:26:23 Proposal for psql wildcarding behavior w/schemas
Previous Message Peter A. Daly 2002-08-05 17:22:20 Re: [HACKERS] []performance issues