Re: Hypothetical Indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: msalles(at)acm(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org, Sergio Lifschitz <sergio(at)inf(dot)puc-rio(dot)br>, Maira Ferreira de Noronha <mairafn(at)yahoo(dot)com(dot)br>
Subject: Re: Hypothetical Indexes
Date: 2004-10-12 21:02:43
Message-ID: 6710.1097614963@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marcos A Vaz Salles <msalles(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2004-10-12 21:09:20 Re: plans for bitmap indexes?
Previous Message Andreas Pflug 2004-10-12 20:48:36 Re: PL/PgSQL for counting all rows in all tables.