Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6HQr-00DTZx-B2 for pgsql-general@arkaria.postgresql.org; Sat, 19 Apr 2025 23:17:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6HQp-003OAU-IG for pgsql-general@arkaria.postgresql.org; Sat, 19 Apr 2025 23:17:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6HQp-003O9n-2D for pgsql-general@lists.postgresql.org; Sat, 19 Apr 2025 23:17:08 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u6HQn-000w5N-27 for pgsql-general@lists.postgresql.org; Sat, 19 Apr 2025 23:17:06 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-6ff0c9d1761so25207947b3.1 for ; Sat, 19 Apr 2025 16:17:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745104625; x=1745709425; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=AS/4RAji7jzhukEhhho8etn0RlGJYUeYT53ynqFBatg=; b=WvplSCgqkA0wDfH2gmuRUUO3KBTzFAAV7ln0E++2BMAyItrFLt/ur/NBNEYO9/Gsuu 4D0cRhcU0KXMz0R3MELEeqKC8O1XlAH5rj5qQil2WPd2anWUd2GNqPrAvEz2zIhZ2m76 fJGNRdZZcWMUoMpN0rt7Bkb6ekGQoh02wdCidYCgu7oqOW/mD65ue02CA3ejjjrseBAz u+PIDRcq49KcgtwUnGfR/av0LmV2Bat9UiDXcYyJZlQWhOPplpEp2TQh7Ghfm0ems63a 2Znbp3kIoB9VWZ+jqtxiVUYxy0upT1vLqoUikMcqX5GLPWMAIn60rJVIo60tBdehzbNu LhBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745104625; x=1745709425; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=AS/4RAji7jzhukEhhho8etn0RlGJYUeYT53ynqFBatg=; b=QPXHqfcrl8WGJorB2y3AaXso2SLa6QpzU4LO7sAvewpQ4YxiraCk67ovHQ7OQlUF+h nM+ugda9vhJ7ubNXXEI1C/OSMYsRHyxzDbvW3bweyG0cP+/cGnDrsaSgoVGwV0eNObKu tOmP6qFT8qHu20zt/pk0RtFnP1ERPnWF+JPJVhA8wMXdDLr5umRFfI6LSKjcQItxwASh ysfeLeg3kEAjcDR1bnfRoS5zUh8aAJ8nQX6VzDtGQ0l2UzS6ko1gxsu4CzMPjjKS1oPJ pU0y33aoegvF6ZRJ70GMKuhGiq+f7DVPO29f8gtJRg0IVrlrkRUWbJZLYwghV+FUXS7Z j9Xw== X-Gm-Message-State: AOJu0YyLmbKBniPmo/14Q5KemUt03boD7rpl7EHW2RvCck5wNvrV7Lg/ Go9qkNEQfFisZXpH7orqFa52IaklRE0MTeNxhZjCrSXDrhmHomz85EQLKqALmd4N46LYmCmps/6 SVbUKvGXZ+3RYsydFLCkgnp1NydQ= X-Gm-Gg: ASbGncvQRSu7NkABQUIPttBTou28RolQPoPHIVVxYwfynQkjk8g5WPSUyue7aZbE1PG Isv8a56LqBmK3EhgnvvRsnxy8E+q/22gllQ3o/DAX2wbaMegAudB4O/8UA1+4geCnkzbs6ED8M8 UoxJpM/3vfx336dirPr8NDYeTDvz2OzX6HtliiI8+VCGDLCJkt04CW0w3R X-Google-Smtp-Source: AGHT+IHevIUp8yzdecLFqqzyGHpVkDjZ44YMSliEIet3WWXCbAV8z4h2q5FCHEgdQpXA2U4qE1qwl5RNv9q7KnyoJ9o= X-Received: by 2002:a05:690c:4443:b0:6fe:bf9d:5de6 with SMTP id 00721157ae682-706ccb04f2emr105376657b3.0.1745104624590; Sat, 19 Apr 2025 16:17:04 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Igor Korot Date: Sat, 19 Apr 2025 18:16:53 -0500 X-Gm-Features: ATxdqUEHiKebErFapc87bHq69322adeTiEjJSFBqtLXfw823_w9pG76o4CEAvM0 Message-ID: Subject: Re: Clarification on the docs To: "David G. Johnston" Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000003ea852063329d58a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003ea852063329d58a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Dvid, On Fri, Apr 11, 2025, 9:04=E2=80=AFPM David G. Johnston wrote: > On Fri, Apr 11, 2025 at 6:49=E2=80=AFPM Igor Korot w= rote: > >> 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. > > --0000000000003ea852063329d58a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi, Dvid,

On Fri, Apr 11, 2025, 9= :04=E2=80=AFPM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Apr 11, 2025 at 6:49=E2=80=AFPM Igo= r Korot <ikorot01@gmail.com> wrote:
Hi, ALL,=
On the https://www.postgresql.org/docs/17/sql-createindex.html#SQL-CREATEI= NDEX-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.=C2=A0 The docs are correct in how they remove= duplication.=C2=A0 I'm undecided on whether that is the best presentat= ion choice.=C2=A0 I would at minimum place a new paragraph after "own = set of allowed storage parameters." so that "The B-tree, hash...&= quot; begins its own line.

B-tree:
fillfac= tor
deduplicate_items

Hash:
fillfactor=

Gist:
fillfactor
buffering
SP-Gist:
fillfactor

GIN:
fa= stupdate
gin_pending_list_limit

BRIN:
= pages_per_range
autosummarize
<= /div>

Could you indicate the d= efault value for every option here?

Thank you.

<= div class=3D"gmail_quote gmail_quote_container">

David J.

--0000000000003ea852063329d58a--