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 1sc9BN-004MK5-On for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Aug 2024 19:52:21 +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 1sc9BK-00GgHC-Qr for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Aug 2024 19:52:18 +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 1sc9BK-00GgH4-Dg for pgsql-hackers@lists.postgresql.org; Thu, 08 Aug 2024 19:52:18 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sc9BD-003qkW-VK for pgsql-hackers@postgresql.org; Thu, 08 Aug 2024 19:52:17 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-81f921c40f2so49260139f.0 for ; Thu, 08 Aug 2024 12:52:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723146730; x=1723751530; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=QMJ3Dv0fD90kLHm+yDQ6mKCr1weeuFWJu7p6WkDE4Cg=; b=A7zgZcD6jmBFZWsm383i0peGATkUvHiuH64F5rKLQwIG/PXj/HCgq9zwNlrnfX7xaD alUAs43iq3T34FAt1HYzkNJqO2r5Tcu9ZLMsdJ7nrfTrbPvlSrwSE25YfLRe7wCdEELa 8OK7vOzLDyFnImQuSGrhLGwMy//S39cjRlQvT1W2FIvluawqCWtNkzqk5GUaHXkeosAH wijcJwrJojmbcmPF0LkPDpWKL0VR2P4cOSoyUtz0nlNOmHxFZIimNMhE+2OROuem9QBs zTgKGeBNy13MQ0QMfMLGmZKRyXqU7QNemdto31fkkVGNWGcZoH6vii8XcveQhN2gMab6 HMkg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723146730; x=1723751530; h=in-reply-to:content-transfer-encoding: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=QMJ3Dv0fD90kLHm+yDQ6mKCr1weeuFWJu7p6WkDE4Cg=; b=H/LOX35sATvpKPsiM1M4FNr4qIvx9SVcJ4dEvtTsOakhuT6I3SYgQErIrfzq2+PItC pLHc9IEtfjhiNDjClF9r64C23BGdkyRuXo3NjAn3JlzDbp9R4VeJnrdhyqwL6/NvYq/1 8zuj6zpqDExi5eHL4reC5pO2etJZI5mojcBdSTcKBNBWgoBt+iFUEVu3nrSCKQQ/PIww H52KVcxArg41/Q/AnEPLPMiYpvDhZ4Qzu1CrREHEiG8tgQPkh2HNLuVpclnPmCLMyWDb qYiO+gvmvDra6v1bvMFcbvw3DJJpZO1ROOgFxb2azc94fZlM62xGDa8IpoE6wqvzrRdT 4Tsg== X-Forwarded-Encrypted: i=1; AJvYcCV90Lequ/8mcfmXP63uOwXKUIncuba9P5I6L5L4bpp7q0K9FaIAESwhT42WRgcxo+C99hd0tCKV3R/r1b0GiNrIZZBEL6cC/r48Lo/R X-Gm-Message-State: AOJu0YwCB5IhKzKHm6W8Nf7LtA+4GRlJmgK3In7O1ZVD0asGxuTJOjhn juP1d8kxhIB9jnhShiY5rO4uv3oRdfybpug//SXWqcAtIbMpnDGm X-Google-Smtp-Source: AGHT+IFCvTjirXnHZQf790eQfFGpO278uyXTSy8KP6b/nVLmchKS7rx3SErtpKDsBFZVX2h04ZcbJQ== X-Received: by 2002:a05:6602:48a:b0:817:49a2:fcf7 with SMTP id ca18e2360f4ac-8225385531amr403603139f.17.1723146730039; Thu, 08 Aug 2024 12:52:10 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-81fd4d3a774sm416503939f.24.2024.08.08.12.52.09 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 08 Aug 2024 12:52:09 -0700 (PDT) Date: Thu, 8 Aug 2024 14:52:07 -0500 From: Nathan Bossart To: Bertrand Drouvot Cc: Sami Imseih , Tom Lane , Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: Restart pg_usleep when interrupted Message-ID: References: <33287B8A-3CA0-494F-87D3-C9D85C6468FE@gmail.com> <19E276C9-2C2B-435A-B275-8FA22222AEB8@gmail.com> <50E1D6AD-3E51-4E45-95A7-7B20DC037DCB@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Aug 08, 2024 at 06:49:27AM +0000, Bertrand Drouvot wrote: > 2.2 CLOCK_REALTIME: Its time represents seconds and nanoseconds since the Epoch. > It means that we´re currently about 237 years away from the limit. So even, > if we were to say add 2 "recents" of them we are still about 183 years away from > the limit. I hope to be retired before then. -- nathan