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 1tvKLA-003X68-L0 for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 18:10:00 +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 1tvKL9-006AQX-BM for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 18:09:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvKL9-006AQO-0y for pgsql-hackers@lists.postgresql.org; Thu, 20 Mar 2025 18:09:59 +0000 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvKL5-000BON-2R for pgsql-hackers@postgresql.org; Thu, 20 Mar 2025 18:09:58 +0000 Received: by mail-wm1-x333.google.com with SMTP id 5b1f17b1804b1-43cf58eea0fso6515355e9.0 for ; Thu, 20 Mar 2025 11:09:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1742494195; x=1743098995; darn=postgresql.org; h=message-id:date:content-id:mime-version:comments:references :in-reply-to:subject:cc:to:from:from:to:cc:subject:date:message-id :reply-to; bh=HmCLQG4aNq1YzKsXLrTmZg1V2UbJSDL0nHeUfITs2Qg=; b=epbv7DsRCqddLqOCM9ezHMjl3qYLdV1LR7w+p8cQ4aqs/k9p/V+5KU0GvIBwdaTCpN QTle7+zhRdMthCc9JteVAEyMadTM518TY75yxGUxzkwxLr/wVOp3R0Y6L/01mGtSXB2F vwyg5b5LC1nng84xy0G+MYeatlyt9kA9ucAzh+b8FZyJGT/rL0tGJMIqPnqkMzBl+lB0 SSH7g5FtCkSLpAsVBcA5tQo/7zAfFNQkBOvOW6uAxxXvU2P1dPoNi4WFiJy8/YIjiXRj rFnXOK+RB69/pogCxBlGakADnDj331qC+szjZYWhKTkA6DJKS1dPzlUFbRW+rpfgASaf 6nhA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742494195; x=1743098995; h=message-id:date:content-id: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=HmCLQG4aNq1YzKsXLrTmZg1V2UbJSDL0nHeUfITs2Qg=; b=bw1o85MljGd78eNL/O3lmSGYt7Nr7VLXlFJ/n0b/kLB3mYAXwPyW+VT3R33nXfj9an 52zc18HsO9Prs4nFUhRgBXY9m7c0FqD9cCTEF+iS/J9NKokeWRETXVC2yUO2NPUtR/Jt C7S3cHLbaPAY9b3O7OJCIp5MKETAY0wZtFJJUaeX1/BCV/E0mQOjuuXbQprVa7cat6aA j7vBOIZF/UdWMLm1GKdz+3JjCeUBAoEO3ZQ5uozYKyxROnT8AJp0t3xsFJ1PsRu5VHW6 +hswiaVrboOYTYRbBxtsLxKModLRIymMzBMSSB/Ebt8Tqt7/xNzTM6skpQ91Eu2LhgPI LlLQ== X-Forwarded-Encrypted: i=1; AJvYcCX2EVLw41XgzTJkZnBEG2v0J7CwlVIzJxsgbwHyoYF81eAPHt/tY/TpNFPxI3a3wBtwDuSgkOq/zbausQqp@postgresql.org X-Gm-Message-State: AOJu0YyQwMPp1tcMttHkvyjDjgXJ7uonq4VJ6Abnhw5LNTJLsORCMgd4 9t8MrwNhIM3vi3N90uD11VIofDPGzIsHxBt1Y6ZOWaeBvUjmjEeTDphhHz7t+AE= X-Gm-Gg: ASbGncvemPXOEMz7tbrBlegSGC+lhp8LeIbmmIO2gJ4zzQcfjZVMykQHB+e9xlu5p2T 98vutV0LlEs6tEc7IYNd+cvk7pXKbTaacueHJnG5/pKV2NB/lpmckm2aN9QG/zYrxLViSoIFx+v 7tAXH0S96zbpq+hA8fIKa16tEjULGPqMsapZOb2SxXvFQpPC/FqOU5LC/B/tN5kAGSTqcqM9trM ZYjs+X9RuDubYhH+OfUvPkpL8BHPfRN+/osqIZxpTpEgTNaJsGs1oNGqUgSxfAB91XXgTAWRPio 83zGQ3T3ubTeGh+7NPrtI7xzKAWmWOkILPL9C6vuJx+LaYVqByOwaNqS X-Google-Smtp-Source: AGHT+IEQKAZKhgDXL7poZv2JQB2K+H6b+vr5YY2oUBfoPkHf7t4V9necJWO/B7X7hSKd2t4WYJilaw== X-Received: by 2002:a05:600c:470f:b0:43c:fe15:41e1 with SMTP id 5b1f17b1804b1-43d509e190fmr1086695e9.4.1742494194679; Thu, 20 Mar 2025 11:09:54 -0700 (PDT) Received: from localhost (109-81-174-36.rct.o2.cz. [109.81.174.36]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3997f9efe61sm229146f8f.97.2025.03.20.11.09.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Mar 2025 11:09:54 -0700 (PDT) From: Antonin Houska To: Robert Haas cc: Alvaro Herrera , Marcos Pegoraro , 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: <127361.1740559688@localhost> <202503201732.xyyic3z35zis@alvherre.pgsql> Comments: In-reply-to Robert Haas message dated "Thu, 20 Mar 2025 13:45:59 -0400." 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: <128544.1742494193.1@localhost> Date: Thu, 20 Mar 2025 19:09:53 +0100 Message-ID: <128545.1742494193@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Robert Haas wrote: > Is there a README or a long comment in here someplace that is a good > place to read to understand the overall design of this feature? I tried to explain how it works in the commit messages. The one in 0004 is probably the most important one. -- Antonin Houska Web: https://www.cybertec-postgresql.com