Hi, Dvid, On Fri, Apr 11, 2025, 9:04 PM David G. Johnston <david.g.johns...@gmail.com> wrote:
> 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 > Could you indicate the default value for every option here? Thank you. > David J. > >
