Justin <justin(at)emproshunts(dot)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