Re: Clarification on the docs - Mailing list pgsql-general

From David G. Johnston
Subject Re: Clarification on the docs
Date
Msg-id CAKFQuwZrL59BXqZB8c1x-dsUwSunDO=D39+kra0z+JraVcV6+Q@mail.gmail.com
Whole thread Raw
In response to Clarification on the docs  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Clarification on the docs
List pgsql-general
On Fri, Apr 11, 2025 at 6:49 PM Igor Korot <ikorot01@gmail.com> wrote:
Hi, ALL,
On the https://www.postgresql.org/docs/17/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS
its said:

[quote]
The optional WITH clause specifies storage parameters for the index.
Each index method has its own set of allowed storage parameters. The
B-tree, hash, GiST and SP-GiST index methods all accept this
parameter:
[/quote]


These are the index methods and the valid lists for each.  The docs are correct in how they remove duplication.  I'm undecided on whether that is the best presentation choice.  I would at minimum place a new paragraph after "own set of allowed storage parameters." so that "The B-tree, hash..." begins its own line.

B-tree:
fillfactor
deduplicate_items

Hash:
fillfactor

Gist:
fillfactor
buffering

SP-Gist:
fillfactor

GIN:
fastupdate
gin_pending_list_limit

BRIN:
pages_per_range
autosummarize

David J.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Interesting case of IMMUTABLE significantly hurting performance
Next
From: Igor Korot
Date:
Subject: Re: Clarification on the docs