On 03/12/10 08:14, Jeroen Vermeulen wrote:
> On 2010-12-02 00:48, Ana Carolina Brito de Almeida wrote:
>
>> We would like to inform you all that our extension to PostgreSQL, that
>> includes hypothetical indexes (and soon index self-tuning), is
>> available through a sourgeforge project.
> Looking at the sourceforge page, I'm left with one burning question:
> what are they for?
I believe they're for performance testing. Add hypothetical index (takes
very little time). Check estimated costs with EXPLAIN. If good, add real
index (takes lots of time).
Of course, they're also good for indexing hypothetical data ;-)
-- Richard Huxton Archonet Ltd