Excluding common values from the index

From: mnikulyak(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: Excluding common values from the index
Date: 2017-03-11 23:00:31
Message-ID: 20170311230031.1429.23255@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/indexes-partial.html
Description:

Rather than a report of an error, this letter is a suggestion of improvement
of PostgreSQL.

As per page https://www.postgresql.org/docs/9.6/static/indexes-partial.html,
PostgreSQL avoids using indices when retrieving common values.

Then, maybe, during the construction of an index, PostgreSQL should be
detecting such common values, and exclude them from the index automatically.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message elliotchance 2017-03-12 06:09:37 DECLARE syntax is different from the 2016 SQL standard
Previous Message johnjdevine 2017-03-11 16:24:34 incorrect assignment op (= vs :=)