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 1sduBo-0024qf-Co for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Aug 2024 16:16:04 +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 1sduBn-0055VR-2T for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Aug 2024 16:16:03 +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 1sduBm-0055VJ-OS for pgsql-hackers@lists.postgresql.org; Tue, 13 Aug 2024 16:16:02 +0000 Received: from mail-qv1-xf2a.google.com ([2607:f8b0:4864:20::f2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sduBk-004g3W-BS for pgsql-hackers@postgresql.org; Tue, 13 Aug 2024 16:16:01 +0000 Received: by mail-qv1-xf2a.google.com with SMTP id 6a1803df08f44-6b7a8cada97so31927176d6.3 for ; Tue, 13 Aug 2024 09:16:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723565758; x=1724170558; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:content-language:references :cc:to:from:subject:user-agent:mime-version:date:message-id:from:to :cc:subject:date:message-id:reply-to; bh=G8cAJFcd1zpiU+6OIWnAP+BWlh4s3mOXuqvXyiihG+Y=; b=IUqpD1JL9ClugwocWmK7s7GS1dcblrWJPcLiAvlik3GIIpGiVa4fCmvN3awbK2UMXV /nqiLVI9EmGOIhHRI5/Xcff7iEnRjqI4pC+tVHjpRZLu0tVsxuzauXeQRqa7Avp7FX/I ribJAcjBQMSOK6bApMzRze1uY6gS1vTjW3jTJtgfR+OV4TBirk0f+823yLTpIsr3rC0U XSGeEjApeO56dAir7ZFTREoBmXb4+Vc+2SE9wZebgP/grfnCLoCH7lV0TCdlX295u1O5 IDDhytyA9T13igKb1O+qajg1utrJOez5AiW8O3SfGG8w+86i4Cwdptpy8P2omitnJYa9 X7rQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723565758; x=1724170558; h=content-transfer-encoding:in-reply-to:content-language:references :cc:to:from:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=G8cAJFcd1zpiU+6OIWnAP+BWlh4s3mOXuqvXyiihG+Y=; b=JmlHHqDz8TvrvjkJAJ1rdP+QFfTcdzda+cdi2cmy/5xwQSmhsBEqREzIeIns+QojGa 2Qq7RV3iPGCuOOiSaoguF8UZ+3Q17kVL28EujcBjoHszWeENayF5JKyGmzZRHIQ3qOVx oGvsR75yxOXndnxTxDzXvAiOu6AGQqyHDE6lrj/rjzEJ6IsH3uzvinO5C+g5fb7hye3n nZnQUgs3SuTrBLlAMVGnWtj4TJa79Ia1fZ3JZA8qYU60TsLzxoUHHNk/q6evX289MWW8 n9Y5Cup5QQY1YY1g+obLfSqpu7GNAwqjquOGsf0+cb0KAlnYRA0PIKvZU8lDorJr0AgX bfGg== X-Forwarded-Encrypted: i=1; AJvYcCWuN+6G539s+tho1A65IXRjX3RjmGM6KkNti3j66Bg83GQ431IhNb9z0B8Vx6aGa67UM500TiVxW0zaeZsV/D90zasDCMJI3A3B13AC X-Gm-Message-State: AOJu0YwzrWhLb0LNUkLIrviwIDhhbB4f//N11jfImbzJatrNRnBlFHt+ JiB6/0ouGWYu0wGjy51TAqlKlAc43Md9iKF2JiQCodx5mZ6r2aEC X-Google-Smtp-Source: AGHT+IGGOKRdMtcEy6xUA/NmlP95qlpWBNyV9bEkOql1NLZAzzTR1nO72+uZBCvMIs67owN+oPefIg== X-Received: by 2002:a05:6214:5412:b0:6b5:def0:b60 with SMTP id 6a1803df08f44-6bf5d164e0dmr170666d6.4.1723565758306; Tue, 13 Aug 2024 09:15:58 -0700 (PDT) Received: from [10.81.2.40] ([15.248.6.116]) by smtp.gmail.com with ESMTPSA id 6a1803df08f44-6bd82e2f5e8sm35218506d6.93.2024.08.13.09.15.57 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 13 Aug 2024 09:15:57 -0700 (PDT) Message-ID: Date: Tue, 13 Aug 2024 11:15:56 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Restart pg_usleep when interrupted From: "Imseih (AWS), Sami" To: Nathan Bossart Cc: Heikki Linnakangas , Bertrand Drouvot , Tom Lane , Robert Haas , "pgsql-hackers@postgresql.org" References: <2b5ac681-11d5-470d-af40-89ead9a868aa@gmail.com> <90ec1618-58db-46b3-8c9b-13616ac839a7@gmail.com> Content-Language: en-US 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 Please disregards this point from the last reply: """ 2/ What if there are other callers in the future that wish to instrument parallel vacuum workers? they will need to implement similar logic. """ I misspoke about this and this point does not matter since only vacuum sleep matters for this current discussion. Regards, Sami