Re: Ad Hoc Indexes
От
Peter Eisentraut
Тема
Re: Ad Hoc Indexes
Дата
Msg-id
200802182109.35449.peter_e@gmx.net
Ответ на
Ad Hoc Indexes (Justin)
Список
Дерево обсуждения
Ad Hoc Indexes Justin <justin@emproshunts.com>
Re: Ad Hoc Indexes Peter Eisentraut <peter_e@gmx.net>
Re: Ad Hoc Indexes Hans-Juergen Schoenig <postgres@cybertec.at>
Re: Ad Hoc Indexes Peter Eisentraut <peter_e@gmx.net>
Re: Ad Hoc Indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Ad Hoc Indexes Justin <justin@emproshunts.com>
Re: Ad Hoc Indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Ad Hoc Indexes Justin <justin@emproshunts.com>
Re: Ad Hoc Indexes Justin <justin@emproshunts.com>
Re: Ad Hoc Indexes "Stephen Denne" <Stephen.Denne@datamail.co.nz>
Re: Ad Hoc Indexes Justin <justin@emproshunts.com>
Re: Ad Hoc Indexes "Stephen Denne" <Stephen.Denne@datamail.co.nz>
Re: Ad Hoc Indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Ad Hoc Indexes Justin <justin@emproshunts.com>
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 по дате отправления
