Covering Indexes
От
David E. Wheeler
Тема
Covering Indexes
Дата
Msg-id
7138506E-2A5D-4AA6-A8CD-DC9FB4D7344E@justatheory.com
Список
Дерево обсуждения
Covering Indexes "David E. Wheeler" <david@justatheory.com>
Re: Covering Indexes Andreas Joseph Krogh <andreak@officenet.no>
Re: Covering Indexes Simon Riggs <simon@2ndQuadrant.com>
Re: Covering Indexes "David E. Wheeler" <david@justatheory.com>
Re: Covering Indexes Simon Riggs <simon@2ndQuadrant.com>
Re: Covering Indexes "David E. Wheeler" <david@justatheory.com>
Re: Covering Indexes "David Johnston" <polobo@yahoo.com>
Re: Covering Indexes Andrew Dunstan <andrew@dunslane.net>
Re: Covering Indexes Simon Riggs <simon@2ndQuadrant.com>
Re: Covering Indexes Bruce Momjian <bruce@momjian.us>
Re: Covering Indexes Jeff Davis <davis.jeffrey@gmail.com>
Re: Covering Indexes Jeff Davis <pgsql@j-davis.com>
Re: Covering Indexes Merlin Moncure <mmoncure@gmail.com>
Re: Covering Indexes Jeff Davis <pgsql@j-davis.com>
Re: Covering Indexes Jeff Janes <jeff.janes@gmail.com>
Re: Covering Indexes Merlin Moncure <mmoncure@gmail.com>
Re: Covering Indexes Robert Haas <robertmhaas@gmail.com>
Re: Covering Indexes Merlin Moncure <mmoncure@gmail.com>
Re: Covering Indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Covering Indexes Simon Riggs <simon@2ndQuadrant.com>
Re: Covering Indexes Vik Reykja <vikreykja@gmail.com>
Re: Covering Indexes Rob Wultsch <wultsch@gmail.com>
Re: Covering Indexes Thomas Munro <munro@ip9.org>
Re: Covering Indexes Eric McKeeth <eldin00@gmail.com>
Re: Covering Indexes Jeff Janes <jeff.janes@gmail.com>
Re: Covering Indexes Csaba Nagy <ncslists@googlemail.com>
Re: Covering Indexes Bruce Momjian <bruce@momjian.us>
Re: Covering Indexes Cédric Villemain <cedric@2ndquadrant.com>
Re: Covering Indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Covering Indexes Andrew Dunstan <andrew@dunslane.net>
Re: Covering Indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Covering Indexes Alvaro Herrera <alvherre@commandprompt.com>
Re: Covering Indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Covering Indexes Aidan Van Dyk <aidan@highrise.ca>
Re: Covering Indexes Jeff Janes <jeff.janes@gmail.com>
Re: Covering Indexes Florian Weimer <fw@deneb.enyo.de>
Hackers, Very interesting design document for SQLite 4: http://www.sqlite.org/src4/doc/trunk/www/design.wiki I'm particularly intrigued by "covering indexes". For example: CREATE INDEX cover1 ON table1(a,b) COVERING(c,d); This allows the following query to do an index-only scan: SELECT c, d FROM table1 WHERE a=? AND b=?; Now that we have index-only scans in 9.2, I'm wondering if it would make sense to add covering index support, too, where additional, unindexed columns are stored alongside indexed columns. And I wonder if it would work well with expressions, too? David
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата: