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.96) (envelope-from ) id 1vlwAR-005UmF-2v for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 21:36:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlwAQ-006OKx-06 for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 21:36:38 +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.96) (envelope-from ) id 1vlwAP-006OKp-2M for pgsql-hackers@lists.postgresql.org; Fri, 30 Jan 2026 21:36:38 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vlwAO-000E9n-0i for pgsql-hackers@lists.postgresql.org; Fri, 30 Jan 2026 21:36:37 +0000 Received: by mail-ed1-x536.google.com with SMTP id 4fb4d7f45d1cf-6581af9c94aso4949111a12.1 for ; Fri, 30 Jan 2026 13:36:36 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769808994; cv=none; d=google.com; s=arc-20240605; b=VO9gm1j+0uAU1qkkw6LJFGvfKB1YWMYzwk0UXkcBS7dCmxjdtGDf0a27tAA9eDbSlI tvy/6do4zzaO02PeiDd+LRk84QHVEh45bhAT/NXsUTBbEjMQcqFlHHeHjhzLwDOz51mM 25g4vJ3OXNRgTDphCORs0VMoMN5ibWL2zUccbKU9TXt+pYq2breHj0vZlsJaa6ClYjlB E+6lYmAmYeDe/YKPUpstrydLr790tCG3vqGWQMXey/Ml6TPhzEWjbt4WVQPUvdc2F1U2 3ZQZuFW47DkyTtgmedEo1Zx0nRPB/PwulIFVXCV+koHZ/VW8HQzoXIBzsAdLmJpeApDq M2Yg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=dxkVogwpFWXE73cT7nqNc9CrcoQ/h7ZgDJHRJBCkv44=; fh=umGHnoK/HlZhvc7fTvDz3fJRMhmtv5gtQzInGO2mArg=; b=BB+5CoY/CJRwNeMDCAnE8W/SREb6qflb3Ehga623Isx03/kjKgO9F74WeN1IuKPiiw 0TxS5AQPMHKn9kNz0B9ey9fZicsrio3SSaTUTlrbYJZuc9stsDaYLJ+kJMwexLL8pJO4 XUfeAQ7RXEGddIHmfbNhUf0t2yETBYls2BKw05ApmPRNoV7dhW8GvYo/mcX5JEYgm4e5 XrelS6HEb8+Z21sT3xy68zsNrSYJgXH/r5IZKMYB9VM7XGldxKD716+yqhnmeBNaYhx6 VMVAAkPBISRElMLsjwpQ3jQhWhmfh2zoaWllrgsRBSOab+D4Ss8cLRRN5oQOuBhDWHCo L0kg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769808994; x=1770413794; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=dxkVogwpFWXE73cT7nqNc9CrcoQ/h7ZgDJHRJBCkv44=; b=hQFykOwv9HK9i8k5JXPfedx1xZ5ij3FMXmjc8yoo9OMyO9M2fuYS/7sPXkU5oBejgo 2QtiN5d2xhw4kMTTSKUnZlbybzxxaXx9t9kDRkalizAy3LBEZLiE4UUmvsfw2lsVAPf1 pcj+oGa2clKxKaNFLk4UESmW9tsihlK/H6uzIzndunUF9LgprOSAA8gSaofPZLVLaKpH VmPpjm/Q3rJCJmkLrL+o1W4xxr1KeqUibku8ZB7eydOtYOBbPZ5qf0uYfy3ktgDq1kev pVj2bNZKvArkG8Az+A7Uy4m7qVY5FUFXWwZrK4CsdTO/ZNPMFN3cEo4d/Yw3oA6ziKY8 scOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769808994; x=1770413794; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=dxkVogwpFWXE73cT7nqNc9CrcoQ/h7ZgDJHRJBCkv44=; b=AUO2UyVs9Mxf7+HsKG27TAvyr8HpPPXUqp3eNt0oITs4sov3olfDkZtgEmcVDc6hhW /UEfCpXbm2tac1gHIM1C0eRdQjwUcMxOtZnp4qISEMzOgEg3uJAAeNWeFJmvYlAb2YDV MrXzpn8maV51PSrCWQsZuDqF6PWcMt7c9FEK5Piz1kTuQ6ip7aJGStWFC0Is1H3iM1se a/N8b/JtdqSUhG0aexz7os4gxcCOJ9hm4UQA02TDlkdta1esZMUyP06cwjGGiP6qb0tj RZyXG9AEMoRns7NmwHGKiXrDfuxcVAcm1zNyjwIFY8BZA63eg2VcL/tPLyurz6kgGPju TEsw== X-Forwarded-Encrypted: i=1; AJvYcCXxCjdPWBQKgmCF2JILbVxyr0lEvTBcV4fOWfu6bjKIK12/OkEyn8XxjnYd1OriaFgQk1pixJOUnGJqzs78@lists.postgresql.org X-Gm-Message-State: AOJu0YydzbX3CiYtQS+f9SxLAnIHR2doW1/BLPGu4FST7qH+ySLGV1Ch uQYuvA53N+phD3ZFMHcsg12KqvE57qCfv/tHxRBsndQ2XpGopPaZiZ7pu0K6mLTo+Ey5QqS793w 1XyERyIES4uoIjf9B4x2d6IgPhtNy1H8= X-Gm-Gg: AZuq6aIPXzHJCF2+Y1xNY9s53ZOmh1BXqbg6PysjwitDF6c9EV6/kwxVMAjHVDNcpfR O9hejtMUEUbczW1vrd+sLAOJPp9rRiBeMk2YbsOEd+LV+6TM0PY4uIehHfBdVazecz+EVi2aBlB 59ZYekSIvtsLlVSi+zjUHYkG6od0y2d07pOg+3quMttCBUh1Cbj/cs9sFOwUZSiw9s9PV9QlcrY MG9IEIMCsUFRTRkcP0wmBmz6E+3xSwJX1Zgyb2QyCATvEriyDdi+LM3gS2wZujxoGhpCw6uTq7F QjRRdWNe3heidSU5zaPYsG6LCQ9J X-Received: by 2002:a05:6402:51d2:b0:64b:6330:2fee with SMTP id 4fb4d7f45d1cf-658de558215mr2592036a12.11.1769808994327; Fri, 30 Jan 2026 13:36:34 -0800 (PST) MIME-Version: 1.0 References: <6BC5DBAB-6084-4BB8-8450-52E9648AB021@gmail.com> <7F5BCD7A-764D-4D8D-8E27-6F2CAAEA1CEE@gmail.com> <4379FDA3-9446-4E2C-9C15-32EFE8D4F31B@yandex-team.ru> <7ib3sa55sapwjlaz4sijbiq7iezna27kjvvvar4dpgkmadml6t@gfpkkwmdnepx> <2b09fba6-6b71-497a-96ef-a6947fcc39f6@gmail.com> In-Reply-To: From: Melanie Plageman Date: Fri, 30 Jan 2026 16:36:23 -0500 X-Gm-Features: AZwV_Qg5PRl5v70bPHsj7XtvuaJieCCUMOtOydhEtMA8UiKX5p1GhPh4Ve0Q5c0 Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Kirill Reshke Cc: Alexander Lakhin , Andres Freund , Andrey Borodin , Chao Li , Xuneng Zhou , Robert Haas , PostgreSQL Hackers , Heikki Linnakangas Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jan 30, 2026 at 4:25=E2=80=AFAM Kirill Reshke wrote: > > > create table test_vac_unmodified_heap(a int) with (autovacuum_enabled = =3D false); > > Yes I did try this, but it does not help, because autovacuum runs on > catalog relations, still causing fail. > > We cannot disable autovac globally in regression suite, so I propose > to changes this to TAp test Andres suggested making the table a temp table. He said other sessions vacuuming catalog tables shouldn't affect the temp table horizon. If you try that in your repro does it fix it? - Melanie