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 1tnD5d-003BUt-47 for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 08:48:26 +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 1tnD5c-0019dc-00 for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 08:48:24 +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 1tnD5a-0019cw-Pe for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 08:48:23 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tnD5P-0009n2-1H for pgsql-hackers@postgresql.org; Wed, 26 Feb 2025 08:48:21 +0000 Received: by mail-wr1-x434.google.com with SMTP id ffacd0b85a97d-390d98ae34dso198944f8f.3 for ; Wed, 26 Feb 2025 00:48:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1740559691; x=1741164491; darn=postgresql.org; h=message-id:date:mime-version:comments:references:in-reply-to :subject:cc:to:from:from:to:cc:subject:date:message-id:reply-to; bh=KCwXoyqE7DLNN3e3Sl93B1P0EpvK8w2yEalyE+mWJnE=; b=EORMr5corc6BNNQh8fe0wDwPsEXuJiXnHfganUDldhxcJ04xkmNncOazchOcMnbD58 XGKAHO7bCCHdKRBWw/kiJpg+v/jUjAeznMLezqm2z96/DMcFbseXxrpg+52xWDWy5gjr o2BLPbYxaevUWy4AwBn01SIteAgT7WRadXzIj81SXAuP8p/ST0HrkyYEh3Hr0E3uGdsZ cz3GAXyRXf0N4ZB0hqPXL4xzFsHzdYCxwKyOwPzNEiS4nbBu8aqjez66x/pQ1Czu+Uos TG2L41I+W+BrVpnfD9inIk2gZtm/GEMyKzvxM3SBbQ/24AOTdSb4HB80GaCwvwjH/1hr Ws6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740559691; x=1741164491; h=message-id:date:mime-version:comments:references:in-reply-to :subject:cc:to:from:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=KCwXoyqE7DLNN3e3Sl93B1P0EpvK8w2yEalyE+mWJnE=; b=jJv3UelV/mW0u6rgXh8g3NOpeBJT5pPf3m4J+tlEVoReewDUy6B2FjCoigtYMFQnOe z/IWDT+QFC52RLr9dqt1/2BsSUsgdAIhXzd8mTBZvgYbfZnk6zTRnOlumZeE42wNpHTr 0MPbiFG0Gx2eptq9JpNG1EHku73m0VeYYwPYI8IkXFkacQ26XVAH1ieiBwNy6XQMkECY bcLsmxRNaqpSR7/Yc8T/+iXuI3sm1MQeM8CwEMrN2iZDlsDj5qhNc6YEpdU+GL9DDwgS tIm9M+px4wH0nstEj5xLYT5cSmKkxmL/cV8mxsVoQyjMvx8wwA3HevuJU+3Fii4FoGt6 Be0w== X-Forwarded-Encrypted: i=1; AJvYcCVvzqveKNuDqElv3/deNTZ9HOkb0NizJlyK86LZ+p1MvdW0/WIYhjUxieiN722ucIQbb5MbAlDauJm8mqtd@postgresql.org X-Gm-Message-State: AOJu0YzoN6WOfNLbcY+yOm2XzHIJsIYGVzYdXEAPOTvQMuloLuQziLen l3p7CqzXSWLMMyqGWnUVk2bMpoIlRRIDfkaHrnTHeDKqxzUYN0wd9MOmvgOCfKs= X-Gm-Gg: ASbGncsyi6SkA+4+0jktJY6Y/6BQ5feOVYLW6Addc+xEGbymeVEIoMmYwGxBcQUW4Fs rM5hDxTtWr83IhqyjN5J3kNC2CEL/PYI0WQwmJgaW5lurmYGjDlisaCW9oaygSi+d2iTlenv8aH FRvS5m+4RUwq5gkLiSMhNdD796snt28PGd0uTiN7D1t3/2z1bN1CNaC9nftSAlY3U4vyg4L+obF iNIwX8yAIlLpr204ch2vp0CWzvm2eRgQX6zk47LTxotyYJw5R1oiLJ4cN/p5EtE4dYy125yGvJp YMlFGMRA5CAGja73p34aGdlAOEM+kfzxbOjVRA== X-Google-Smtp-Source: AGHT+IHY0fM3YJofsRoRFUvgZoh8cbwXbj1K7THRH2hQ5ce/avmTG8ofuIXHEDkrcoPCs0+0HskLJQ== X-Received: by 2002:a05:6000:1542:b0:38d:d69e:1314 with SMTP id ffacd0b85a97d-390d4f378f7mr1558411f8f.9.1740559690320; Wed, 26 Feb 2025 00:48:10 -0800 (PST) Received: from localhost (109-81-174-36.rct.o2.cz. [109.81.174.36]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-43aba549eb9sm13179115e9.37.2025.02.26.00.48.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Feb 2025 00:48:09 -0800 (PST) From: Antonin Houska To: Marcos Pegoraro cc: Alvaro Herrera , Michael Banck , Junwang Zhao , Kirill Reshke , Pavel Stehule , Michael Paquier , PostgreSQL Hackers Subject: Re: why there is not VACUUM FULL CONCURRENTLY? In-reply-to: References: <202501301529.ejggbtao2skr@alvherre.pgsql> <63871.1739984882@localhost> Comments: In-reply-to Marcos Pegoraro message dated "Wed, 19 Feb 2025 14:40:32 -0300." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Date: Wed, 26 Feb 2025 09:48:08 +0100 Message-ID: <127361.1740559688@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-=-= Content-Type: text/plain Marcos Pegoraro wrote: > You mentioned fillfactor only on cluster notes, would be good to mention it > on refsynopsisdiv, I think. ok, I've added a note to the first paragraph. Attached here is the REPACK command as well as the patch set that adds the CONCURRENTLY option. The new symbols have been renamed so they resemble REPACK rather than CLUSTER. Please note that 0008 is a new part which makes the setting wal_leve=logical unnecessary. -- Antonin Houska Web: https://www.cybertec-postgresql.com --=-=-= Content-Type: text/x-diff Content-Disposition: attachment; filename=v08-0001-Add-REPACK-command.patch