Re: Hypothetical Indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Hypothetical Indexes
Дата
Msg-id 6710.1097614963@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Hypothetical Indexes  (Marcos A Vaz Salles <msalles@gmail.com>)
Ответы Re: Hypothetical Indexes  (Marcos A Vaz Salles <msalles@gmail.com>)
Re: Hypothetical Indexes  (Thomas Swan <tswan@idigx.com>)
Список pgsql-hackers
Marcos A Vaz Salles <msalles@gmail.com> writes:
> In order to make index selection possible, we
> have extended the PostgreSQL DBMS to allow the simulation of
> hypothetical indexes. We believe these server extensions may be of
> value for addition to the PostgreSQL code base.

This would be of some value if the optimizer's cost estimates were
highly reliable, but unfortunately they are far from being so :-(
Without the ability to measure *actual* as opposed to estimated
costs, I'm not sure you can really do much.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: PL/PgSQL for counting all rows in all tables.
Следующее
От: Greg Stark
Дата:
Сообщение: Re: plans for bitmap indexes?