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 1tdPzz-0073iK-JH for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Jan 2025 08:34:07 +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 1tdPzy-00AkHE-Im for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Jan 2025 08:34:06 +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 1tdPzy-00AkH5-8k for pgsql-hackers@lists.postgresql.org; Thu, 30 Jan 2025 08:34:06 +0000 Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tdPzv-002Jcc-1G for pgsql-hackers@postgresql.org; Thu, 30 Jan 2025 08:34:05 +0000 Received: by mail-wm1-x32a.google.com with SMTP id 5b1f17b1804b1-43621d27adeso2949875e9.2 for ; Thu, 30 Jan 2025 00:34:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738226042; x=1738830842; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Vaf9Qx+hH91SWUh6Wc463q98VoW3YJGehsZRafJnTys=; b=fAFpPMfw+9RUUgk/KgPCQ+JwVPbW/1gov+cqi7agDBDvVf71gOAE1GSU/8BMy610zc wVf20Sca1hnnSUH16V2bLG4CqJE3S4vgr+qYNzeTEC/g41pujrbl9M3SK82OAwmhFd7b 1DjabDNuITOU9oIi8wNf8KpHk2TL59AqlV29c7dxAKLM77uN7hl82vjlOU92uHlv3QME h6hjSKS9LiOOo1zwvRdasSVhTzreGsCfe25S/yhp+Pu5mbY+B/RPBlx7+FaAy37WVoea 0wVwMhCMaZunkxhFS2y2EgUdK2XobPLmrPVCaIHWkqle8QWXQ7ZfABwJkN8GxPTC/Gc8 RNQQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738226042; x=1738830842; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=Vaf9Qx+hH91SWUh6Wc463q98VoW3YJGehsZRafJnTys=; b=lXNDmZBqH68dcHFy+La8X0qZvC8Z/k74XhxyPU9WFpKhWHse1h8usUdVJ8UV5NBOjz AzvtrJQTp0XAHNTImYo/yk8s9+h0THv64J3aQ4+9k683FPeDrM3k9jN/0mOiTCtK2VIZ wKs6VcXaojfbHsM+a+V/hjqIY1wloJvTNNbI2GfIHv3FhNHoJEHXt7PVoKWPf4AghUjD js4zdtFq648E+UcTAKB12hUTvSCkUhQhlPvRk1ffWTlHTRjjDc8sOVb6gLofcPpvcweU Y+GVkpGg8qzKOQkRYxb8IE+v+BM1J0HwPcaB4EHCJUAJ5mnFcLEfVXWl/R2Et1XyIoKm pcNw== X-Forwarded-Encrypted: i=1; AJvYcCXGfUR8uYcENkNfdU5N6P7+utu4kDDgFC5R3ra+FEyuCl7LiW11Q5ZXfnxHgjeKhVtAjMFOsVjzjm9QPr3u@postgresql.org X-Gm-Message-State: AOJu0YyeqbmxPD8bf7LamahicQemDLyuft/SyDkPfpiToTngUfVUZBaE wnHmdfkffpA+h1GdslaugNmHd+xFcttTFSafmSFtftjiPmgpiNrG X-Gm-Gg: ASbGncvaTksNeCqNBD9OcY+4oyNvolYcBgN9yjU7M30IQmwF+t6f0jikYRdVc+k8bS4 Z2QTyHFV8mENJEmVrAFpjyHvIjx+pOTwL+9f8n18rtnHHcIgPnQFvI+J9Yuw8qJw2aG/SOb01Aj y3NaGPhZTlpNj82dbmd1+v9enle5QIfudBqSIp+C1NDzMNfQVEh0xrlukQxqq7T2CYI1p9tBLbB MIXeY7vyB6Kw93KpszK4e7SRvwq3W+MGe0iXXfIgS0IW9IHDNXC3ZmJ86rb2MsHWoiCHqaxMC8Y kjCaqhIHOv/z/cirOPRcmenVLCwbZbwGC6fCigy5z3IKV4Tk/H8= X-Google-Smtp-Source: AGHT+IFFroDdWQTq2LgpY9Sb2FY7fgsZN4tTuajSxoNGGOOJ9zyvgpNeBXONu62X9e2k98WZLlnvig== X-Received: by 2002:a05:600c:3c98:b0:436:e751:e417 with SMTP id 5b1f17b1804b1-438dc3c398emr54326925e9.7.1738226042313; Thu, 30 Jan 2025 00:34:02 -0800 (PST) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:1023:fa01:30f7:a173:8273:ac3f]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-38c5c0ec7e6sm1291852f8f.19.2025.01.30.00.34.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 30 Jan 2025 00:34:01 -0800 (PST) Message-ID: <679b3979.5d0a0220.115578.3e08@mx.google.com> X-Google-Original-Message-ID: <20250130083401.GA27216@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1tdPzt-0008K2-6F; Thu, 30 Jan 2025 09:34:01 +0100 Date: Thu, 30 Jan 2025 09:34:01 +0100 From: Michael Banck To: Antonin Houska Cc: Alvaro Herrera , Junwang Zhao , Kirill Reshke , Pavel Stehule , Michael Paquier , PostgreSQL Hackers Subject: Re: why there is not VACUUM FULL CONCURRENTLY? References: <202501091952.df7vrzrundlo@alvherre.pgsql> <6250.1736776111@antos> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6250.1736776111@antos> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Mon, Jan 13, 2025 at 02:48:31PM +0100, Antonin Houska wrote: > Alvaro Herrera wrote: > > On 2025-Jan-09, Antonin Houska wrote: > > > It seems you accidentally fixed another problem :-) I was referring to the > > > 'lockmode' argument of make_new_heap(). I can try to write a patch for that > > > but ... > > > > > > > Meanwhile the patch 0004 has some seemingly trivial conflicts. If you > > > > want to rebase, I'd appreciate that. In the meantime I'll give a look > > > > at the next two other API changes. > > This is the patch series rebased on top of the commit cc811f92ba. > > I haven't addressed the problem of a new command yet - for that I'd like to > see some sort of consensus, so that I do not have to do all the related > changes many times. Well, looks like this patch-set is blocked on the bikeshedding part? Somebody should call a shot here, then. Michael