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/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
