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 1v7Avu-00G7l1-Pu for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Oct 2025 11:05:10 +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 1v7Avs-00Bm0X-JL for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Oct 2025 11:05:09 +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.94.2) (envelope-from ) id 1v7Avs-00Bm0P-9i for pgsql-hackers@lists.postgresql.org; Fri, 10 Oct 2025 11:05:09 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v7Avr-0011kI-1c for pgsql-hackers@postgresql.org; Fri, 10 Oct 2025 11:05:08 +0000 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-46e542196c7so16469615e9.0 for ; Fri, 10 Oct 2025 04:05:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760094306; x=1760699106; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=FJsR/qv3jg8/4ByRTLYSBSFNYxTdN2eUAwYbd5NhoXs=; b=ejU3gfYIiqKUxbnunzhSzecbTT5dNnUH4WXROvPGv3K+CnWbThlwOrJvTjYeH4cYCs kMaFYqiBKE8NgUxKrw6x/mWoiXK7m8mQwEIl+J1tkDD+Z9VAvSogQ3bzMpoLLbyrGjWR ZwRaJcZ+YGsMI6ndGiwc0/sFNITrAwVJ6yh5Fifpi/GNqjyKK6qpWreeVUjTidfLQoJ/ RQc0MCHpP99T17DQO1QlsZcA4FZuaazXqEwMc4gIOnwT1ZNPp6/jPqjZXk/uTkk49Ofb /stySr/LeeOCyYau+5lEV6c370wqnplSATE7IBZomzWw6Tx9GEpeucwt4FC0jifFYh5e y1kg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760094306; x=1760699106; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=FJsR/qv3jg8/4ByRTLYSBSFNYxTdN2eUAwYbd5NhoXs=; b=aqdhibgUB0oXQL7YY2/U9aEpCjCwnIfi1hzyINwdmbPW5++QPXzknN783b0IJHJDI0 QT2w4iSHjvbsPfm40HQyzOw+fDwAZ88jsdpLtCGymKOoRCNwBsZdJM33gvSnHVCS52Mg bi32r+ChSVRSkOadNDHdpw346b8AuasTdxSZNOccUjdxFUN9VY0fJoIHyktM1yVCP2R5 OaR2dId/li9DF4wJId9K4cyPZ5Y1Ho5GHqi5DzQMcIUH5ZXjQ0TVhpQZe+7jZYnK6CVt o2ZAAggNsYyx5zoiEwAJO0HmG4XqgkxMTfR5qYflhvvIUhW2Oyqs+36Tok8hL/P8FkFr cWAw== X-Forwarded-Encrypted: i=1; AJvYcCUZfWGq6QiP810N8BsO+ElcNr5871NvOqqpO9TgeY4lIAeuYa4Av1J6GIATnryDhZawfIF1hPKp2S+7ugIT@postgresql.org X-Gm-Message-State: AOJu0YwqGmpH9Vs6Oc8m+qhCuulRj/yIAoL30deyKOKEyYaWO5PAaDFn iGM9QOpdtijDz2oc4hmef+A53vAZuiSUB12yJ3VoB4GWBfNjbVdA+0bu X-Gm-Gg: ASbGnctSji27HVfOHyqD6/IGctz7cjm3pVJXeiyEFKvkY0dEIACnc10kZLiJTyQ0ILA 0Rw+e/UbBYcmNwiVHlQJBjx9b5ge0FfSS5ZLnjaOEpvM1yEPItBKTRYyaSNAFIpUBaAuZpKPpGE yWs2A3tMzvwx8dAPldmfJczmnuPqK/2VMQ51VphhMUx0Aq5Fp+B4xmtxpYlO6oDOPmP9s9+qjC8 pr+x1kLEPbRTH2K0rtV/QZRHkNcWaCCpF1isewtIkf+yP/efNCXNid3nxmvcOuTxGarlzkUFkyW 7dHxTz14NqzEWnlRyCREUsAxSG0HY/hgt3nsCWLEz0beCrh0gPqZG8NTKc430dXT0QBr6AwSBYm KPINTPAg3+SwGlkX8atAcGotbY8lOhNHKmPdaOqu0nMo2z7IRU307 X-Google-Smtp-Source: AGHT+IEU6OYxz2NbbZuh6sLwT/sZW3Ms/M0u2Cg57D88xiQHoMiZ20kE5fwgA1PaXlwCSzFyVhKfNA== X-Received: by 2002:a05:600c:a411:b0:46e:1b9d:ac6c with SMTP id 5b1f17b1804b1-46fb1f77c2bmr32889595e9.17.1760094305867; Fri, 10 Oct 2025 04:05:05 -0700 (PDT) Received: from [192.168.15.198] ([80.251.191.198]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-46fb49c3e49sm38942235e9.16.2025.10.10.04.05.04 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 10 Oct 2025 04:05:05 -0700 (PDT) Message-ID: <43160fac-0c75-4e43-8894-2e1131075127@gmail.com> Date: Fri, 10 Oct 2025 13:05:04 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE To: "Aya Iwata (Fujitsu)" , 'Chao Li' , Peter Smith Cc: "Hayato Kuroda (Fujitsu)" , Michael Paquier , pgsql-hackers References: Content-Language: en-US From: Andrei Lepikhov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/10/2025 11:04, Aya Iwata (Fujitsu) wrote: > Thank you for your comments. I updated patch to v0006.My company also employs a large number of background workers. I also reviewed your patch. It looks nice to be committed. The only question I have is whether to make sending a termination signal a default behaviour and let the flag deactivate it. -- regards, Andrei Lepikhov, pgEdge