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 1txhXa-00DPH8-3X for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Mar 2025 07:20:38 +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 1txhXY-001Avn-Ao for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Mar 2025 07:20:36 +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 1txhXX-001Ave-Vn for pgsql-hackers@lists.postgresql.org; Thu, 27 Mar 2025 07:20:36 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1txhXV-001TGI-0R for pgsql-hackers@postgresql.org; Thu, 27 Mar 2025 07:20:35 +0000 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-43d0618746bso3917315e9.2 for ; Thu, 27 Mar 2025 00:20:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1743060032; x=1743664832; darn=postgresql.org; h=message-id:date:content-transfer-encoding:content-id:mime-version :comments:references:in-reply-to:subject:cc:to:from:from:to:cc :subject:date:message-id:reply-to; bh=n9k9jBljDO1pP97oatMk7cyXPsUs+PTtT/3aW1cPbbs=; b=Hz0JCIdlL27ubWIC4PMxN6YhAg5Ou/Eh1hpmu8Og1ubWCh+QmURxCnIrulX3eHO7M4 yUUDipNEGhyuJH3wv+FOYeXkMpnFqby2GRGoVWGJbUG0RPOPdjD3cJUQ9BEu6A6wQelb qANWVL92/Tpu3146WcVLHT2AA48FZdPH3YGUn4Uaa2u1eHNFaZHz+NS4xEQOZR4JUYK9 1d8gZ5rI0D+Hr9hPJ1kEw70pyH07mrrQeVWV8glnQYdR/McYOiCVpQBw2qU4UMaRhJVF wOUoCngPApjZUyuk5LpWMgEGMk6s8qgQcn/cipNETZCxOJEhE4UdcZKviABV86Ug/Mzb DmnA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743060032; x=1743664832; h=message-id:date:content-transfer-encoding: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=n9k9jBljDO1pP97oatMk7cyXPsUs+PTtT/3aW1cPbbs=; b=danySH08CtEnCVhwy/oILyj5RW7en5i8OuIElferBjajIbnI/SQGJo7s0/yamL4Lf6 QKvj/tAjJjzNnkgyeLIwZ45sVoW9LRXORMtiMiK5EO3ksXCk+qGlAMmFfRiPGXViZX// S/7Po32LbmJeygSJ+o9LyqYx3ZZlWvUrXpgMDEl3h86MIpCV+qHaZtJYAX7Slujm5yHW 8GRbT7mvIIjRiads9VmX20exjbRTIErEN4xrF3AB3z1pHfgmgDxUWuZrYiMaXY4nmIKo ymc0zCQuOugJaVOyrX1fhSaBy/LQLLFb0NAg84Po561RfbIhXowoMIvsDzBUZo9uEH0E +/RA== X-Forwarded-Encrypted: i=1; AJvYcCV+Ll4g5A5TKqNUSd6eHZbHuX5JwAV5H7GtAePpgCm9RltMZhO0jOA/+1QxrUhdMUXSaa82CnHGpfHf4fUu@postgresql.org X-Gm-Message-State: AOJu0YyYjwEDni1mQsMWmIzTlhnFetvCjMGY1lRehTyk6xUIX07aAlU4 J5pFOAm16d16foS8wzc9ROULmnMq51TXPpVLO4bkVxJ8hTrA9hNDLhiSkyX7omg= X-Gm-Gg: ASbGncs3RjHeIe0+Fq1B/TTlOB+jw+j2vljeEt1N2AJAob1m53ZGru+Mrr60RcEHjUp i8yEANNxOwXqN9tdSXFI5PKDEZsgqHbSFJ5TiPx3B77HP/3NBg4NxXEetXtfolR8405l2WK6LRY wTr6nd5+bAL1li7s1PZwsYt+L8hFpiYSmLxEKuInLyOM3SSJYah4ywOzpxnifVKGbr6GsjsnVEp uD7mehmluIWcLSJXVTvbATlJIwIEihYwFl+i6NRLCjob3So78qykAVmG48bKhgATXkmzDCIqpGX e/uDiKH334/nNIMH8aWduGTbJJSxATjYmmPF54Nvv5J7p5Q45iGxTRjD8Yg33GvnB6Q= X-Google-Smtp-Source: AGHT+IFEB7poJPXeI8dO8dFdb9O1uF24UmXfkl8WdBGgXE26iTm+lSa1/LvUFI1P1b4YAvozcG4Ecw== X-Received: by 2002:a05:600c:1c86:b0:43d:9d5:474d with SMTP id 5b1f17b1804b1-43d8a2f4f04mr7817645e9.0.1743060031735; Thu, 27 Mar 2025 00:20:31 -0700 (PDT) Received: from localhost (109-81-174-36.rct.o2.cz. [109.81.174.36]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-43d82e83609sm28146605e9.15.2025.03.27.00.20.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Mar 2025 00:20:31 -0700 (PDT) From: Antonin Houska To: Alvaro Herrera cc: 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: <202503251432.o6obtgywjow5@alvherre.pgsql> References: <202503251432.o6obtgywjow5@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Tue, 25 Mar 2025 15:32:46 +0100." 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: <6058.1743060030.1@localhost> Content-Transfer-Encoding: quoted-printable Date: Thu, 27 Mar 2025 08:20:30 +0100 Message-ID: <6059.1743060030@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro Herrera wrote: > On 2025-Mar-22, Antonin Houska wrote: > = > > Alvaro Herrera wrote: > > = > > > I rebased this patch series; here's v09. No substantive changes fro= m v08. > > > I made sure the tree still compiles after each commit. > = > I rebased again, fixing a compiler warning reported by CI and applying > pgindent to each individual patch. I'm slowly starting to become more > familiar with the whole of this new code. I'm trying to reflect Robert's suggestions about locking [1]. The next ver= sion should be a bit simpler, so maybe wait for it before you continue studying= the code. [1] https://www.postgresql.org/message-id/CA%2BTgmobUZ0g%3D%3DSZv-OSFCQTGF= Pis5Qz1UsiMn18HGOWzsiyOLQ%40mail.gmail.com -- = Antonin Houska Web: https://www.cybertec-postgresql.com