Re: Documentation for create unique index is insuficient and(because of that) incorrect - Mailing list pgsql-docs

From Alvaro Herrera
Subject Re: Documentation for create unique index is insuficient and(because of that) incorrect
Date
Msg-id 20181120180831.frne3ck56mfdh573@alvherre.pgsql
Whole thread Raw
In response to Re: Documentation for create unique index is insuficient and (because of that) incorrect  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Documentation for create unique index is insuficient and (becauseof that) incorrect
Re: Documentation for create unique index is insuficient and (because of that) incorrect
List pgsql-docs
On 2018-Nov-20, Tom Lane wrote:

> So what I think I should do is reformulate that discussion to talk
> about making covering indexes with INCLUDE, and then mention in
> passing that you can also do it without that as long as you don't mind
> the payload columns being part of the index semantics.

That seems sensible.

> I'm also wondering whether to move that section someplace earlier
> in chapter 11.  Right now it's near the end because it's mostly
> info about an implementation detail; but it wouldn't be hard to
> make the argument that covering indexes are more important than,
> say, indexes with custom collations.  Should we move it, and if
> so to where?

I think right next to 11.5, which currently completes the topic of how
are indexes used, is a good place.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Documentation for create unique index is insuficient and (because of that) incorrect
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: Documentation for create unique index is insuficient and (becauseof that) incorrect