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.96) (envelope-from ) id 1wzcYJ-0047hY-0U for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Aug 2026 16:02:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wzcYH-0032bn-03 for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Aug 2026 16:02:05 +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.96) (envelope-from ) id 1wzcYG-0032be-1o for pgsql-hackers@lists.postgresql.org; Thu, 27 Aug 2026 16:02:04 +0000 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wzcYE-00000002huN-46RL for pgsql-hackers@lists.postgresql.org; Thu, 27 Aug 2026 16:02:03 +0000 Received: by mail-qt1-x832.google.com with SMTP id d75a77b69052e-51c08df8513so311841cf.3 for ; Thu, 27 Aug 2026 09:02:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1787846521; x=1788451321; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=+Osm8JX4gVQDi6LXEP8bq20j3oXoxCHyXXm28pZ5c1s=; b=mF92eg3tfnIXxM3e5DBJWNcn4HgpNCDzPkjBW0rzu8L1KeZWnIsQ5iTHxl7d48HwWJ AchKfgS/nfA3bEdiTTe0MZMULEO/cAatcw8v9ZSe+E3XHBsn+0aMTBj3hq1oIfFSMpvB I9VPBKlKUqWVUprGgOgWc6Y02sSZIOpnCxWebUEn9r1ntLvs7oQNaphN4OQChEEVtZ5P 2enzi0edAvof9290GRu6Od12RnlDCTPQAyE9mgRQwh3rF78P3YbNTuVB0yjuqpR7DTM1 l0A27aUGhqEDQtHgpfGVDRyssSFJE37C+J+jgvZDwwR8oZinj6SqeVglQD952QqRs6Hw szHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1787846521; x=1788451321; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=+Osm8JX4gVQDi6LXEP8bq20j3oXoxCHyXXm28pZ5c1s=; b=W+0yeshLqIJaS2le0mrooLf6gmPeqteTDdTLhzM+2a8/zE/kiXM1Lw3q6VU9PSPPjn ZJQTw9bsgMUM+CFmu1izMhAyj3toYvQH3Sbe3ga0dLw3IZJohfwEHVxTzdfEXaauSorl AT+Qo/xA1lWGZWkUOYqWf4Dx5gNIgywQ3pV1xg2IftEI2kJbX1NEnRB1eEwwZ5rrANeA i4YI8Gg4qrp/uHisYaLtgGxRz9QQqLMTBIuIXcrtOx5R9ErIyiJJ3DhgY71BAydAfNkW nDnPkPKpX/qPeW0b7gqb/5mc2PW8h0zmwBEEqpx1tiOoIoVQR3tnXHHnB2cmvLv55np/ x/LQ== X-Gm-Message-State: AFuF++nad1Wz2BNQgGjlVwk+8h/1uhWHYWbX0q2pGil0DoAzayb3gOWy aQKwrnocH45oySzz22RPcPeEFVzH1+70iM5ID76NDUyL7MUTHggj7/rgd5VTtw== X-Gm-Gg: AR+sD108rkFF1zm1y539Ggv0uS5Mjs8ooYh2NaGbRQ0B0RAManM/AdQQJY1p4Av1Mzk Vv/QwymACmTpv1dU/yziXHEyl7eYtYUbmyVm7aLLKsa1z+kOS5lq3zTvqCAfCJUEO0hAHNx8E38 ROHdk3W54FOpJVrf9SouLIuDs+ZK/ADpQd9Gvie96vDRPiKPGl7XNXYryXkNqMpDczOATYGe/rR jPvQfwDtHXbhbUgIMNSEzNIZ+9YQa1MEtoerR8Q0iJNXVxhrMDHCsA5d3OrP1/Sx5noNRLEwa80 zMOqfeWidqqnh2/Fv+7+rHJ5hTzYOy+WYS1Vjvuo42ApB2OSli35AB6hunh+byS9xQVw1jtbmGl eE31E8gJdaMGOZa5itYKDA81PfMYA6cuZXNSfZBDlQlKguXQ+7BPylYT4mmzUZOZI/U9PjbIRtF LluxBqK/VdlwA05bIjNU3CjXpNqwJOkSd4g0dIqUi/u8Akkhdl6vHWRFg8+Dek7ex0648y6U45x uqWkGcpubzc+L3LF24NBtz1rqYEYhoK5pEY9D4QIP/0WZCC4Pt033JbEqDSszLmLhmuWXxuIeYj Nxl/7UtjGjiAYXA= X-Received: by 2002:a05:622a:4d94:b0:52d:9db6:6c28 with SMTP id d75a77b69052e-52e42283b20mr173048691cf.13.1787846521033; Thu, 27 Aug 2026 09:02:01 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id d75a77b69052e-52fb91e4245sm249261cf.5.2026.08.27.09.01.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Aug 2026 09:01:59 -0700 (PDT) Date: Thu, 27 Aug 2026 11:01:57 -0500 From: Nathan Bossart To: Adam Lee Cc: pgsql-hackers@lists.postgresql.org, Antonin Houska , =?utf-8?Q?=C3=81lvaro?= Herrera Subject: Re: CLUSTER progress: wrong index_rebuild_count for tables with TOAST Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jun 26, 2026 at 02:45:57PM +0800, Adam Lee wrote: > When I run CLUSTER (or VACUUM FULL / REPACK) on a table that has a TOAST > table, pg_stat_progress_cluster shows a wrong index_rebuild_count. During > the heap scan the count is already equal to the number of indexes, but it > should be 0 until the indexes are rebuilt at the end. Hm. Isn't this a regression in v19 caused by commit 28d534e? -- nathan