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 1sQTD8-009zG4-PU for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Jul 2024 14:49:54 +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 1sQTD7-00CyM4-6r for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Jul 2024 14:49:53 +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 1sQTD6-00CyLw-L9 for pgsql-hackers@lists.postgresql.org; Sun, 07 Jul 2024 14:49:52 +0000 Received: from mail-ot1-x333.google.com ([2607:f8b0:4864:20::333]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sQTD4-000tgj-54 for pgsql-hackers@postgresql.org; Sun, 07 Jul 2024 14:49:51 +0000 Received: by mail-ot1-x333.google.com with SMTP id 46e09a7af769-6f855b2499cso1932496a34.1 for ; Sun, 07 Jul 2024 07:49:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1720363787; x=1720968587; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=Px8YX88e4E/caJBS3DXJ9OjM5xVBVrpwjASsAPu/VJY=; b=dPgPLUWF2SzWC01WJt5NvSY4+1gmfrAjdzoKO5huImOFhL5n2pCSyODJlkSIlxY1Lu /jpc9lBArR9ilylWEFPSua5TGbjyPUIXlHegfe6cMKYWu1hmBRRq1UC1UHQPj6LeZiKG DmptEy7A8rY9wKOIpDytoq/cR3tdcBLkQtKtE= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720363787; x=1720968587; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=Px8YX88e4E/caJBS3DXJ9OjM5xVBVrpwjASsAPu/VJY=; b=jjPk7N+fYB6CYiz31f4lxvWhwp767IU9xbPfwmJIF+c7VeP+hexPG2VwLUDrGuELFH 9uX02i4838dwx/Ci3OdVzScCTpKD49kSa2dBqgKfXQnrN12ceLY26Z16BPCM+bZq4Qhd k4fX90gD+u9mR9P5LbQBqf+XcMHXksCp3FJGPv/BYa8NgSEd3tz0f72QJzsfYhYUzzTo ApWFp65D9AddQLNLkWR1ZphA2Bh2be78f/hHXqmplwvECekE+/Tzd9VMIGdKgaIAbfPO Q0513fkss4I1cK5PV0KzrZPTbfHQB/r8whH5I6I/bxCzkQvDLYfAOQboNftk3llJz9T0 wZVw== X-Forwarded-Encrypted: i=1; AJvYcCWfwWWOPZ9rUHvO7K7I9TtgMKgt9yaoSZMGN6gHC3HooGCJkF9KV2rz72/4PzYhw3eDMx2n4sJthe5FvbOpEiY4WO2LOVGS3/YNAXEh X-Gm-Message-State: AOJu0YzVNLFel90YVWrQTtnixRiyCHa6E7b500C5nDNrJEIbvywirYGG osKC7E04DR6eYHIe4FC4aYqhNdH324lTLJNPeFrGTfX2loXZ7KeQBeekXXB1sA== X-Google-Smtp-Source: AGHT+IGiLtUnP1o8lZrPUJ4RkuFUrLIWxoLNv0yerJ5zzZZMJ4hOs6SuZZ4fK+qir4dB6Yb+YVYxlA== X-Received: by 2002:a9d:6847:0:b0:703:6ab8:1fe3 with SMTP id 46e09a7af769-7036ab82622mr1257854a34.15.1720363786995; Sun, 07 Jul 2024 07:49:46 -0700 (PDT) Received: from google.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-70365a28d2bsm451526a34.41.2024.07.07.07.49.45 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 07 Jul 2024 07:49:46 -0700 (PDT) Date: Sun, 7 Jul 2024 07:49:44 -0700 From: Noah Misch To: Melanie Plageman Cc: Thomas Munro , vignesh C , Andres Freund , Pg Hackers , Heikki Linnakangas , Nazir Bilal Yavuz , Robert Haas , "Andrey M. Borodin" Subject: Re: Confine vacuum skip logic to lazy_scan_skip Message-ID: <20240707144944.58.nmisch@google.com> References: <20240306234733.nd4a636colxkgq2e@liskov> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jun 28, 2024 at 05:36:25PM -0400, Melanie Plageman wrote: > I've attached a WIP v11 streaming vacuum patch set here that is > rebased over master (by Thomas), so that I could add a CF entry for > it. It still has the problem with the extra WAL write and fsync calls > investigated by Thomas above. Thomas has some work in progress doing > streaming write-behind to alleviate the issues with the buffer access > strategy and streaming reads. When he gets a version of that ready to > share, he will start a new "Streaming Vacuum" thread. To avoid reviewing the wrong patch, I'm writing to verify the status here. This is Needs Review in the commitfest. I think one of these two holds: 1. Needs Review is valid. 2. It's actually Waiting on Author. You're commissioning a review of the future-thread patch, not this one. If it's (1), given the WIP marking, what is the scope of the review you seek? I'm guessing performance is out of scope; what else is in or out of scope?