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 1x1gd3-005MRD-2A for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Sep 2026 08:47:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1gd1-00BcTd-1n for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Sep 2026 08:47:31 +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 1x1gd1-00BcTV-0h for pgsql-hackers@lists.postgresql.org; Wed, 02 Sep 2026 08:47:31 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x1gcy-00000003brH-3k8F for pgsql-hackers@postgresql.org; Wed, 02 Sep 2026 08:47:30 +0000 Received: by mail-wr1-x42c.google.com with SMTP id ffacd0b85a97d-485538d3499so322511f8f.0 for ; Wed, 02 Sep 2026 01:47:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1788338847; x=1788943647; darn=postgresql.org; h=message-id:date:content-id:content-type:mime-version:comments :references:in-reply-to:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to:content-type; bh=6JM6QJHkALyo9gIGal4B1X4F/N5298HJdZpHkwvp+W4=; b=PCWKW4t/766OUDcpP5zWJXRButxZAg9+3k2k2c63UT2xk+0lAcyZoGX1+tapSHlRj7 R21nnOQPG3FGa4oKoxh6vbHS3RuY+MmquUeqwj8h/VUGKTx0492KDkSi7AgU1PfPwvcU 4oQYBxhi9Ue6Wsi+Kcu7vlz7WKB1TlnD/FFLqF3lnzsOXhirT8IuiRL9Ii7DF+qAltzT o2vw2AFk4JhGTRgcuMsaEB0C3uMlDTi6CepKewriOUVJDFxOVfgv2mMNBzHk9IylgTZz 0CpUBGY+b5meDS7aAeAfY66eLWrxLEwTiuwlLfItmDRdgXGQdiNydz7KlH0FMFu3Qjl7 paUw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1788338847; x=1788943647; h=message-id:date:content-id:content-type:mime-version:comments :references:in-reply-to:subject:cc:to:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=6JM6QJHkALyo9gIGal4B1X4F/N5298HJdZpHkwvp+W4=; b=JMIpcxlydKuxK6sIw9NU3fnEI3fXigJIu5QAjf+qoSyYj9MJ2L69ez72uy7PQJdGyX R717QYIQ4zHmqCCvcReDX7tVTaR4WMZHQseC1Yl/V8OiVIUKHnuJXXN9mj2MTyxgGinI U+lFMntdwCfBWB+1PXB5ynsQt5TFrdeIeK0qqi6KenYg3K4U6pEKfBWNFmfgFWIB3vJs 7yTodHKBqoU2Jq0rsA8NvWJ0bVsmv47XGrlZbOCWklntADRgTibJVzAuY96IKjkTgsov 14skLH3I3GCJc/Vsxsc0kZamdd2zHrSwrd2Tg7vSKbjPaG19BKH/x3ZbyO+IvtoirKZu N3+w== X-Forwarded-Encrypted: i=1; AKwUvBxzOjCw6JdqftDUAdFgieTP0hsZKW6CJ+zrv9Vc9Ucf9U67jttc3C4UyAd18u0sHp7leUX1YlG/tlr9zHlK@postgresql.org X-Gm-Message-State: AFuF++n7jFXThlr6YlqpNFem4YqCQ4s7ZN93QEQLMmn+7lCJwRwBwkj2 RpI/0XDplLbkKiNkI7ZmjlrVYsb68lE9LbaDCz+4p00rMi5mIzKASNfnfuXZUGEya8I= X-Gm-Gg: AYBFou0EniGHOZaiUPb8qisk0dF4CZHY3q45B/BNN5QsbDr8zMYKEz+5Qsi7sJSTisT SjaZqXZgwb1wU8iOMgr5jgyC24f3u9hqyHVOdM/a1i6O7DRccy13vNeRQTuSLaspKtJ9+p5D3zu 3/WSG9/nHMUMudyNkQR6dGlXcszpbS+Hv6kgPSRALBxRt5uwyW38ogBgAqY+3TyAo9GgN/Rnnyj C1YCU/cQ5a2i7jlk3RhiL12nJjm88Do2jbOEIkVaDXG6KMccNkN4/2UHJd+cuVM7PCdNWqCoun+ ooOc5dUWMVFJdZE/UJkhaCyG/FHg1sbL7CUukoz8qUOPCHi94FTGTD5iFPgImxFVKXqtCkcLx3v 0dl1XS2SksoUNp+Hx7QC9nZf2ZirBuVCAmj6koBh2Q4Pb6O4PUzY5fr43CD+oO9uREm0OHtE3NS BupmErcgR5ERrfGaAi0mpeUtNWpOCaWnatdnxtumpO9bRxV9K0H8y9ddAlQXvSUTWE5pzg9HxSe A== X-Received: by 2002:a05:6000:41cf:b0:484:41dd:ff3c with SMTP id ffacd0b85a97d-48488f18e96mr5320428f8f.18.1788338847345; Wed, 02 Sep 2026 01:47:27 -0700 (PDT) Received: from localhost (109-81-170-190.rct.o2.cz. [109.81.170.190]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-48448e80388sm6186960f8f.14.2026.09.02.01.47.26 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 02 Sep 2026 01:47:27 -0700 (PDT) From: Antonin Houska To: Alvaro Herrera cc: Fujii Masao , Nathan Bossart , pgsql-hackers@postgresql.org Subject: Re: REPACK (ANALYZE) within transaction block segfaults In-reply-to: References: Comments: In-reply-to Alvaro Herrera message dated "Wed, 02 Sep 2026 10:20:20 +0200." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <15396.1788338846.1@localhost> Date: Wed, 02 Sep 2026 10:47:26 +0200 Message-ID: <15397.1788338846@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro Herrera wrote: > On 2026-Sep-02, Fujii Masao wrote: > > > + * that's just consistent with VACUUM (FULL, ANALYZE), which is a > > + * synonym for REPACK (ANALYZE). > > > > Is VACUUM (FULL, ANALYZE) really a synonym for REPACK (ANALYZE)? > > That's the intent, at least. If there are things that work differently, > I would strive to change them so that they do work the same. However, > some such changes might be too invasive for pg19, but I would still see > about changing those in pg20. > > Now, maybe there are things about VACUUM FULL ANALYZE that we don't like > (perhaps, for instance, they exist solely because of even older > backwards compatibility concerns) that we would prefer not to have in > REPACK. I don't know if anything of that sort exists, but if so, I > would propose to seek decisions for each thing individually. Maybe the question was about the wording - "synonym" might indicate that both commands execute the same code. Perhaps the comment should rather say that REPACK (ANALYZE) is (intended to be) a replacement of VACUUM (FULL, ANALYZE). -- Antonin Houska Web: https://www.cybertec-postgresql.com