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 1v6taD-00BTdc-Ej for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Oct 2025 16:33:37 +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 1v6taB-007K6t-0H for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Oct 2025 16:33:35 +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 1v6taA-007K6l-LB for pgsql-hackers@lists.postgresql.org; Thu, 09 Oct 2025 16:33:35 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v6ta9-001GZD-1B for pgsql-hackers@postgresql.org; Thu, 09 Oct 2025 16:33:35 +0000 Received: by mail-io1-xd32.google.com with SMTP id ca18e2360f4ac-93ba2eb817aso109226239f.2 for ; Thu, 09 Oct 2025 09:33:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760027611; x=1760632411; darn=postgresql.org; h=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=GbqjfTBHlM6syjBbgWlxOkoBqAofvzBlWFrj6FbY/wc=; b=eTq8Prbl+STwdkGpNdDjTRtg2rMzpiI+3t2RAin91QU/olk15cyhB+G/UIal+6AAX6 kHBuG3s/SQ+Feqx10RXs8EgoUyNBrltoeR88d8D7Z1CikY8TKqndaf7IDdMt4e+OLdE+ iFJqFBavPO1dIClA59pjj6OIgiCkVDsDHRKF+NTakPDun4icPSvrCZ4vjdgWchIWgl4X aFrb+Uf6VjkBzd2dXm11QvByUwME+o/JecUJhKUCSWoAG2U03EZ1aGt4cAJf6Cf8hlZ8 ZecaASpD2WSocZeOglnei9zKEIURCtssKtZpCISxgwGmi4zell9aSls4U76BK+LTsE4z dnAQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760027611; x=1760632411; h=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=GbqjfTBHlM6syjBbgWlxOkoBqAofvzBlWFrj6FbY/wc=; b=NRVsjPHeCTvGwaoz6KJoDCSDf7AWvuszrDfScT+P8/p4yGtVwkhtYWTzvh7nwaILVD GT6F+IO0pT4oZsP1VixVZg4cSAX2oh4fsisois+jU20YGEkDESnDmLUCifuxVd5rhgM7 FItE48UyGbI6XA4NNsBYRqpct2giqBjVBfPio8ilS14vQHjOWJzyzCPd5R9kVTKXmbUM OyM1CdM8hpHp2VmGBOUmNX/SqnL7jCXt0mVEsMzEx0TXFXHuZ1hdMAjFW0Q0ZZH3IW+a 0DK9KxnWEu0Jfk1QT4H9UqGYnjSpbFCuDZXHaGqKl4IJxHkQihrxuFQq8oXHMBPvoUGb oMYQ== X-Gm-Message-State: AOJu0Yzw8O8nYjhrnW1XDxXYBLP9ClQv6929JQavhC/Gtq/0JlRSZdbF JCj6IiWuPvFg+LOqdWZZkLpZhSRilAsiM8a7UXEg0efO0Mjuxckh0Dbs X-Gm-Gg: ASbGncuf6M32NCZNmWJnu7FO8toXGB0q6ivsBoSwH5KCc+frSVsYmnQDwj7LgokPXbZ kxOCuNUTs2Q+X0JUBzB6VkYJQkoG73H0JP+QUcIP6/opGPgv6jfwTZi4d12zgCTh1Q63qb8YBlo JMZmMTANF0bgSw1+gUk6BMbFtRkrDmWeCGGSrVq4uFO5IjYxUIV10uRzy34BidSidHXj+E9p9H6 HtqMPEHFuvTrVmO5w9KCTEqMEhSiJDoVineWhhe16rfhHbeFxLjsXnfMe6Cdjaeigb1dGXbLRQ7 26LBBKJ3ZvYjI+WftJcq/xp1oC3HqaLDvs5AmvZjpRMODy8Tgc4PX3L9nsOeqmHSLiLS7RlM6XT ZYYKnWvs0SSeXPmhrTLaO9C93EFAStRn49fyhOMCjY6cVaTvYD1/AAB/qTmftOkXrqWgyA4KgdP qwQbnLYsfDAME3Nf/SOEj4N+afL26ER/G0VgNL66CB5VtzNhw= X-Google-Smtp-Source: AGHT+IHdQNdqaoCo/lfIWr135AouGY3MBEEnapZPNlc/744CXzbZYNZ1tmBtyzwpjpvW2GpFQvRugQ== X-Received: by 2002:a05:6e02:12c5:b0:42f:86a1:b8fc with SMTP id e9e14a558f8ab-42f873d1cf8mr85247075ab.17.1760027611005; Thu, 09 Oct 2025 09:33:31 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-57b5ea31e13sm8001175173.18.2025.10.09.09.33.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 09 Oct 2025 09:33:30 -0700 (PDT) Date: Thu, 9 Oct 2025 11:33:29 -0500 From: Nathan Bossart To: Andres Freund Cc: pgsql-hackers@postgresql.org Subject: Re: another autovacuum scheduling thread Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Oct 09, 2025 at 12:15:31PM -0400, Andres Freund wrote: > On 2025-10-09 11:01:16 -0500, Nathan Bossart wrote: >> I also wonder how hard it would be to gracefully catch the error and let >> the worker continue with the rest of its list... > > The main set of cases I've seen are when workers get hung up permanently in > corrupt indexes. There never is actually an error, the autovacuums just get > terminated as part of whatever independent reason there is to restart. The > problem with that is that you'll never actually have vacuum fail... Ah. Wouldn't the other workers skip that table in that scenario? I'm not following the great advantage of varying the order in this case. I suppose the full set of workers might be able to process more tables before one inevitably gets stuck. Is that it? -- nathan