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 1ryxp3-001Ivy-0p for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 17:51:21 +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 1ryxoy-00AcCw-8T for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 17:51:16 +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 1ryxox-00Abwv-O6 for pgsql-general@lists.postgresql.org; Mon, 22 Apr 2024 17:51:15 +0000 Received: from mail-ed1-x52b.google.com ([2a00:1450:4864:20::52b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ryxot-0047OT-Nl for pgsql-general@postgresql.org; Mon, 22 Apr 2024 17:51:13 +0000 Received: by mail-ed1-x52b.google.com with SMTP id 4fb4d7f45d1cf-57215beb09bso617062a12.3 for ; Mon, 22 Apr 2024 10:51:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=f10-com-br.20230601.gappssmtp.com; s=20230601; t=1713808268; x=1714413068; darn=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=G7rj8IM9wRWOeRWzRXNaKEoEqfaG1OwwqTlkwFY27t4=; b=nZRrTjq2awdn7cU+eUFWi08lyeoikPQe240hkb3DeKhW0qHCzKbeJp5+xCN9IqY6Ue a4y7Ff3NUi0qEVZReTCZNt1jlE/GcPjj0t9eCyYw7eN0kM6fUI2U9O26ey1umnmTR/nw hHCpeS+p9mcviTpK9aHm0o4bFaEe2m3NLcXwcm0TqgpPRUVH84tTHOYW1Yp8LudTpmcH 76pda2OQ4xEWjx/ktUjlV88hfuKgRI8H+k1YTbkGtp1sG+s2QSVpopH7Gj59GfpW3RLb xG+c5PMASVXfIE5bvn+OzIK6P5gkuFHV8x20cGtLNW0pu7laj7dv8sPhAfos6pQ6Intf eX9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713808268; x=1714413068; 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=G7rj8IM9wRWOeRWzRXNaKEoEqfaG1OwwqTlkwFY27t4=; b=ajAQeX6fTaGTF0LuCXzceZDKgfVjMkw2qh4pL0WWIuj/eyLzOOmEheBoLR3960Yfj0 9NM7NV0HRwKKtnelkrRvQ7KBYZK8lol1peTLq2R51J/O6Ru5piXt8IQ8CzhfftEOX1Dx ZJpajTCkd3Sbd8lHd38s93EWpmWZanWjxQ9XPH6EKaAL0QruSpzJwBrLB8gaV/lnb42c S3ZMTKHRkwxbiUOwPn9kdH+8eKaQ0pIbM01R1fyoChILLZoQ60fCw0PeZTUSbQlbcUhv v2wtxFrknFbh0GpwAraVu5qNmJMb4fO92xteFvgBuvAxfc/Ic3UbGUrRtwwfVfZlCHnj G+Lw== X-Forwarded-Encrypted: i=1; AJvYcCWPGbf0mQzWn/+iIxqs94EjOKcZ5CCsio6FMkmTeD9CFFgfQ1H7Gqguo3XKrouLc2RYD/IZFdKrFYR2OIEU2n+uKMZYtihwDrEOCL3s X-Gm-Message-State: AOJu0YyUupkFIW5fFvWHkwbnrDs/yGCiAwuEEL0U2EMU6t9vE7bdGVUu 6pigcpYU6PMUCxHkMTg87XRIFoLRCKMKGC4GQn94GB2k1zZeL3FR+YaW0gQgyQMtyFnmftxQU6B aL25WYwOTVxyXfOTmWSo8BakLp3g/Sznicync X-Google-Smtp-Source: AGHT+IH1Mz7tRWnbcS/uqr2sqjod4ND8Tcq+yuAfTcm1/rn87OCwDyf1cdkNpYTp7p6gxHIp9LxFzVCQ6oLORghZgMo= X-Received: by 2002:a17:906:2895:b0:a55:6407:c0c7 with SMTP id o21-20020a170906289500b00a556407c0c7mr6248276ejd.17.1713808268261; Mon, 22 Apr 2024 10:51:08 -0700 (PDT) MIME-Version: 1.0 References: <2870091.1713739514@sss.pgh.pa.us> <3043219.1713795953@sss.pgh.pa.us> In-Reply-To: <3043219.1713795953@sss.pgh.pa.us> From: Marcos Pegoraro Date: Mon, 22 Apr 2024 14:50:24 -0300 Message-ID: Subject: Re: CLUSTER vs. VACUUM FULL To: Tom Lane Cc: David Rowley , Ron Johnson , pgsql-general Content-Type: multipart/alternative; boundary="0000000000000b16c50616b3150d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000b16c50616b3150d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Em seg., 22 de abr. de 2024 =C3=A0s 11:25, Tom Lane esc= reveu: > No ... what would be the difference then Well, I think if a cluster index was defined sometime in a table, it should be respected for next commands, including VACUUM FULL. If I want to come back to PK or any other index I would use CLUSTER ... USING PK_INDEX. regards Marcos --0000000000000b16c50616b3150d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Em seg., 22 de abr. de = 2024 =C3=A0s 11:25, Tom Lane <tgl@s= ss.pgh.pa.us> escreveu:
No ... what would be= the difference then

Well, I t= hink if a cluster index was defined sometime in a table, it should be respe= cted for next commands, including VACUUM FULL.=C2=A0
If I want to come back to PK or any other index I would use CLUSTER ... US= ING PK_INDEX.

regards
Marcos
--0000000000000b16c50616b3150d--