Re: Ad Hoc Indexes

Justin <justin@emproshunts.com> writes:
> Is there any plans in the future to add the ability for PostgreSQL to 
> create Ad Hoc indexes if it makes sense.

No, I'm not aware of anyone contemplating such a thing.  I can hardly
imagine a situation where building an index for a single query is
actually a win.  Maybe those DBMSes you mention were using this as a
substitute for having decent join mechanisms, or something?
        regards, tom lane