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 1u3PzP-00FTOF-GQ for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 01:48:59 +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 1u3PzL-00Gzrj-GV for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 01:48:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3PzL-00Gzra-4v for pgsql-general@lists.postgresql.org; Sat, 12 Apr 2025 01:48:55 +0000 Received: from mail-yw1-x1131.google.com ([2607:f8b0:4864:20::1131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u3PzJ-004qHP-0A for pgsql-general@lists.postgresql.org; Sat, 12 Apr 2025 01:48:55 +0000 Received: by mail-yw1-x1131.google.com with SMTP id 00721157ae682-6feb229b716so27036687b3.3 for ; Fri, 11 Apr 2025 18:48:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744422531; x=1745027331; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Wxmd3tL+sRmtiiDkkPgfG01UKxXjPUWKwV/hPs+HrcI=; b=LvFeE3G9lUTWDc5c+fjhy7GISUFWY7s6CNvPFRbe4BVh4joXsv4mhhhxSriMB5rigd h+oB65oCQlbWw3OPQxOCawIWb/dr2pabLBkRZ8OLm9jh0C6i7VzKxpZ+toZYihEGCQzG bpXfTleTwLYqTPsdDa3WmxYmIOxQOvKLpHqbdLs8HZl1Bocul/4qpCyiQ90bjJLqdNCN Ihl274fwrvtO6Ouew/2o7rs+pnPKbeCTmVTFRiQDvj9N1PtALYiUKDUH6oS/5bnQ5XX2 Tqgneg6bGDvzdlN8jBwjflvGWrJoGvMBdRX9RlFi0NeLtBgvlKDD27osqgGCgkQXxzjF nDTw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744422531; x=1745027331; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Wxmd3tL+sRmtiiDkkPgfG01UKxXjPUWKwV/hPs+HrcI=; b=rzRtefAswCxHjsFjOr58pUlAKlFQnTEpMqYbqcJCydOXvUgADgWE+ueVTdB+nC6GLX VFS/7zpKJprwo983ipYv4Vx+aYCoQTy92Brai1w5VZwPcev337+cM8V16USb+KyZoqF7 wQsO0pPNuqdrWKXycoE5ZjR6FyBMz+wpu+LpfnymCFYHCS2lPJLEILtCBVgm3IXbrrha jfnQTE5VfSEFN9vPNw+dssX90P2w13YZco/wyBxnb0jI4blTcCV8JXVA/eFncYBj2dsQ JnTG5HcUgOOBn2YE0fDVEVXSlZHqXD/qGn01QIOwkcIYBAazeAbKRhtulRs/G9HuwXq+ Q6bg== X-Gm-Message-State: AOJu0YwuE94JSJe56vRwWQ+H/Hhmz8QO8gWrgcDxnUwSDODX1IYEPI47 1vJ6If91IC/+ownvf8oGjYQgU0/UOOpHA2qYGCKlvr4jlYiWTkfeZdVKZcCeEeA9MhmwKfycFi/ dOvRDQASR87beE5vw7+QUXtyS/0RtPX1xDvs= X-Gm-Gg: ASbGncsAqlx0urMoPmOZH0VnF1lFxIWl6U+1fp4+pVYUJN/kbT8Yo6wWw7aIPDepFMa JBTU8WnACQ/pzItGzcBm4lTYzrkVfUtRno/Jp/jl19L4tq7CiKonxjnZvi/glVezfWfarq830Fn /9zsK5tWvAjDBO1EMGjJhV/jG8jwRB1PpJrQ== X-Google-Smtp-Source: AGHT+IEmjBRO2w0Sj3nXTfoAMmjxO8hzdacWH2zDw/B7nZh3WEp1KxkatSv/SgJ/rAc1KDJk2oSSMtdX0H4+Ib1LLUY= X-Received: by 2002:a05:690c:6411:b0:700:b007:a33e with SMTP id 00721157ae682-705599c90bcmr82806387b3.16.1744422530733; Fri, 11 Apr 2025 18:48:50 -0700 (PDT) MIME-Version: 1.0 From: Igor Korot Date: Sat, 12 Apr 2025 01:09:50 -0500 X-Gm-Features: ATxdqUEFtvbqqBcaAw0_1ZXC9y0maZ0hai0g2Oc7dVSJ9fGBFryINp5uRMhCSWQ Message-ID: Subject: Clarification on the docs To: "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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] It states that each index method has its own set. However only 3 out of predefined are given. Moore over after that quote there is a list of parameters. But the last phrase indicates a single parameter. So how should I read that? Is it a typo and it has to be plural, oor the list needs to be ybindented and only one parameter should be there? Thank you.