On Fri, Apr 11, 2025 at 6:49 PM Igor Korot <ikoro...@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.
