Re: Ad Hoc Indexes - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Ad Hoc Indexes
Date
Msg-id 200802182109.35449.peter_e@gmx.net
Whole thread Raw
In response to Ad Hoc Indexes  (Justin <justin@emproshunts.com>)
Responses Re: Ad Hoc Indexes  (Hans-Juergen Schoenig <postgres@cybertec.at>)
List pgsql-hackers
Justin wrote:
> Now for my question It does not appear PostgreSQL does not have an Ad
> Hoc Indexes ability where the Query planner will create an in memory
> index based on the Select, Update, Insert or Delete commands.

How is that supposed to work?  In order to create an index you would need to 
visit all the rows in the table.  If you do that, you could just as well 
answer the query off a sequential scan.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] deadlock with truncate and foreing keys
Next
From: Tom Lane
Date:
Subject: Re: IDENTITY/GENERATED patch