Content-Length: 237018 | pFad | http://github.com/postgrespro/postgres_cluster/commit/fe375d33a184b98510d08f45f55da1338cde974a

30 Doc: rework introductory documentation about covering indexes. · postgrespro/postgres_cluster@fe375d3 · GitHub
Skip to content

Commit fe375d3

Browse files
committed
Doc: rework introductory documentation about covering indexes.
Documenting INCLUDE in the section about unique indexes is confusing, as complained of by Emilio Platzer. Furthermore, it entirely failed to explain why you might want to use the feature. The section about index-only scans is really the right place; it already talked about making such things the hard way. Rewrite that text to describe INCLUDE as the normal way to make a covering index. Also, move that section up a couple of places, as it now seems more important than some of the stuff we had before it. It still has to be after expression and partial indexes, since otherwise some of it would involve forward references. Discussion: https://postgr.es/m/154031939560.30897.14677735588262722042@wrigleys.postgresql.org
1 parent 25c026c commit fe375d3

File tree

1 file changed

+252
-183
lines changed

1 file changed

+252
-183
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/fe375d33a184b98510d08f45f55da1338cde974a

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy