pgsql: Rework REPACK's documentation on clustering

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Rework REPACK's documentation on clustering
Date: 2026-09-10 15:58:27
Message-ID: E1x4hAQ-00000004J2s-1QU3@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Rework REPACK's documentation on clustering

Commit ac58465e0618 moved the discussion on clustering from CLUSTER's
refpage to REPACK's, but somehow introduced a mistake regarding when
exactly can the seqscan-and-sort strategy be used with respect to btrees
(spoiler: it was 100% backwards). Fix that, but also restructure and
reword the whole subsection more fully to try and make it more coherent.

Author: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Author: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Reported-by: Antonin Houska <ah(at)cybertec(dot)at>
Backpatch-through: 19
Discussion: https://postgr.es/m/69CA7636-0359-42B6-B971-16A036698187@gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8db08e2522954916009dccdd88a634b1658bc522

Modified Files
--------------
doc/src/sgml/ref/repack.sgml | 75 +++++++++++++++++++++++--------------------
src/backend/commands/repack.c | 10 +++---
2 files changed, 46 insertions(+), 39 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Nathan Bossart 2026-09-10 17:41:12 Re: pgsql: pg_plan_advice: Add CHECK_FOR_INTERRUPTS() and check_stack_depth
Previous Message Etsuro Fujita 2026-09-10 08:32:36 pgsql: postgres_fdw: Adjust warning message in statistics import.