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 1sqvUQ-00E5uB-RF for pgsql-docs@arkaria.postgresql.org; Wed, 18 Sep 2024 14:17:08 +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 1sqvUQ-00Af3b-H5 for pgsql-docs@arkaria.postgresql.org; Wed, 18 Sep 2024 14:17:06 +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 1sqvUQ-00AekD-2e for pgsql-docs@lists.postgresql.org; Wed, 18 Sep 2024 14:17:06 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqvUM-001ogM-RW for pgsql-docs@lists.postgresql.org; Wed, 18 Sep 2024 14:17:04 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-a9018103214so953229866b.3 for ; Wed, 18 Sep 2024 07:17:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1726669021; x=1727273821; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=hFLt++lByyCY/4A5xjnYr6q6CJP15wpaI1KP5TUjd/k=; b=0eDBdqoxsoQtRfgBgEas1nt5v2zDmFB8FuDpWIwV+b9whIbyI3h+ERDL72S705omjI x7qkWUtCneZ7RwttyHmQwcQPMzHA041cn3wSyrksUwhQ3owTR11RDYSi3ZFTnUCflrMN AHAHgQnytPRrChac1SoqchmkVcgFRyUqpHzYyB1FMSZKRpST9ghBEy/0q5PJ04wzLj9s Cp402/kmSpKWcQPtH/oYQHV0kXeAqMkMK28YDI84gflqFSh03CnvXKdgj0hYJ/pr6/aJ lnw+W5xVBilwwdmI+Um0DsFHkOdDzLYtAijK8CuU2HU3Bya/Kr++Id4ri7sq38L46pkf WV/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726669021; x=1727273821; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=hFLt++lByyCY/4A5xjnYr6q6CJP15wpaI1KP5TUjd/k=; b=ePYHBHnOwsXUmMigcLqhK4Y4amcrwyvD/1Ez2tA0VtjBuBWI0Wvi4ns8hWifDcDQ6g 1hchQPQYHAkQYMGnUJTzdih4JtbYS5b229GK08fz2JkcK6V7ATWelBrosxpalyijajl8 1SahDkurCh9DgwzVqiDKkmsyu1lYqZhOOFhmOWOZ3pnYnyvz/UpcbZlGpMwb0r8j8z8L ULXPbtLc7J/rv8g1sMiEXJyR/ftdu8oAJJbu76JJB3Z+9v1PThkB+RuOd+huEsNsrXUS Sku3DXJxHT7S45Othhc3Q3/1Rz3rbGnvDXlSclnwSGZU3tSRBZX1VaA1tPdTNyMvoVok rXMg== X-Forwarded-Encrypted: i=1; AJvYcCWz9zpta+rxPrjv3aQ62tvDXjIqU3EHff34WioVygdS7QKwHjA6hREzdNEfYxUyRpwF9F+CXLQK46r8@lists.postgresql.org X-Gm-Message-State: AOJu0Yw1PpIe7TkzbrKOxCxFpOCr4+hLXaG0zhBg7ME6hmCqNysENNHl rqgWyAfEepGuisPcnRd2HLACmgYTaK2+dHPyVU3jgVUTJ1ftx8yjXTwZlSYtMGCQl7naXVHQnUq W X-Google-Smtp-Source: AGHT+IHkpP8jUDnu9DZW+EKVq3WQQOk9D42luPRV0gGA6ahjbSKxSP15m1DJUp/x+vOXg5EDg47t6g== X-Received: by 2002:a17:907:f1a9:b0:a8d:6261:23ff with SMTP id a640c23a62f3a-a902944492fmr1951592966b.17.1726669021267; Wed, 18 Sep 2024 07:17:01 -0700 (PDT) Received: from [192.168.218.211] ([41.66.99.119]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a90610f4438sm596025966b.51.2024.09.18.07.17.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Sep 2024 07:17:00 -0700 (PDT) Message-ID: <8111b97628f83e5b7878e1d94ee9f0e54535f51b.camel@cybertec.at> Subject: Re: No details on how to use Hash partitions: no example, no syntax From: Laurenz Albe To: cornelius.roemer@gmail.com, pgsql-docs@lists.postgresql.org Date: Wed, 18 Sep 2024 16:16:58 +0200 In-Reply-To: <172661233659.1128083.16661934750010460090@wrigleys.postgresql.org> References: <172661233659.1128083.16661934750010460090@wrigleys.postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2024-09-17 at 22:32 +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: >=20 > Page: https://www.postgresql.org/docs/16/ddl-partitioning.html > Description: >=20 > I would like the documentation to explain how to use Hash partitions. It > says one needs to provide a modulus and remainder, but the exact syntax i= s > not stated in the relevant documentation page 5.11 All that is documented with CREATE TABLE: https://www.postgresql.org/docs/current/sql-createtable.html "How to use" is material for a tutorial rather than for the documentation. Yours, Laurenz Albe