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 1sdt9z-001uK2-CJ for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Aug 2024 15:10:07 +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 1sdt9x-004gYn-28 for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Aug 2024 15:10:05 +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 1sdt9w-004gYf-OK for pgsql-hackers@lists.postgresql.org; Tue, 13 Aug 2024 15:10:04 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sdt9t-004YdI-8E for pgsql-hackers@postgresql.org; Tue, 13 Aug 2024 15:10:03 +0000 Received: by mail-io1-xd35.google.com with SMTP id ca18e2360f4ac-81fe38c7255so327062839f.1 for ; Tue, 13 Aug 2024 08:10:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723561800; x=1724166600; 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=v3zCA+Lx/uadmbsyM1ZC6w0o3DgzwTgPn93/j8tWvDM=; b=Clhc3caYjMsWfoJqvaGjlVtGTqlzQ4PgUGLE+31bsD8BlLTgi6Y1JA7CbRFdPFLQvQ HJToJZvnwVHyZ9ymU/21b86J4FTQrIgX3KGfmI46DdbSAxtYHHSiae0hhwaomc6FarPz kA8JUO+WZ0kR7zu+67/FaBQm09KMExD0kxZz/OwfrELXnbvSfLdW2QFHpbqtRRQYSZ2O UXDjaAHJWqJotSqiZt+yZtH/OZTs69nVFFDYka3Ozuir5M/N/uDl6ZYRS66Jw+FRhLdi lLCvbI/+g+26pc80kr8PpR0uWo3mDQVfl/gbO+DHt4+nJd/1O51vJbtD4effmU1M0UMc CPEw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723561800; x=1724166600; 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=v3zCA+Lx/uadmbsyM1ZC6w0o3DgzwTgPn93/j8tWvDM=; b=lFb7yFAmu7d8MvCLo2owkcqf7/zeQzH8HM47fneBdEzenG3gxIKqI6iGgiQ58i8SBY UPw+wZehxWaIGPfy1rT1uS1uO0ToN0f9mlKBW9KjPo06kwR/HZOxJcq4nfaFzg6+GETb ZM9d9Xdd7UBzbQrUQa3ukZDj93UsFdqWcl2U0PXtevZs4SxQRnKhSPdzPv6+VkjYxygY YjTIUVXeSA/++2jUVz364lRK/WGS3oh5LsUBgM/Nyv8frA4JJm9b6HvfQOXA1W+LmQev Fhy2s0F0dIwG2Y1uSfftazYz+gr8Np4xVPNjmo00yxniETQmsAQQlMdBclDbyCXcfj+e 8SZQ== X-Forwarded-Encrypted: i=1; AJvYcCULKYjs07zq2GhQvb+vlPQCOEu249tcRoyhq6J/uVH7EmGZ0LGI+A5rFlIgsHHxEk3qIJchWmv7geRr6cPzX1W8Hi7bjA3HAUrwi4ns X-Gm-Message-State: AOJu0YykM7RiZ3eknVxfFJ1tI5ao/qHAM8XJEM2nS/X/R2af9n8HE56u vgNNAWx+gK5B12JJEH2iBJm0Q6mvXove29Xmzb/5ZeucQVbxO9zJ X-Google-Smtp-Source: AGHT+IF5tQhhJq2Mvk3j0xu/TRObzmHs4/pmcgs9ymbnJCKSEBSDFNNVGvqKMhOILa7qkN8Y+Hpx9g== X-Received: by 2002:a05:6602:27d4:b0:824:b312:3328 with SMTP id ca18e2360f4ac-824c9928b40mr681360439f.10.1723561799890; Tue, 13 Aug 2024 08:09:59 -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-4ca76940129sm2496818173.40.2024.08.13.08.09.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 13 Aug 2024 08:09:59 -0700 (PDT) Date: Tue, 13 Aug 2024 10:09:57 -0500 From: Nathan Bossart To: "Imseih (AWS), Sami" Cc: Heikki Linnakangas , Bertrand Drouvot , Tom Lane , Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: Restart pg_usleep when interrupted Message-ID: References: <526E6A51-FE30-47C4-85C8-F2D18877607F@gmail.com> <2b5ac681-11d5-470d-af40-89ead9a868aa@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2b5ac681-11d5-470d-af40-89ead9a868aa@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Aug 12, 2024 at 05:35:08PM -0500, Imseih (AWS), Sami wrote: >> Skimming the last few messages of that thread [0], it looks like Bertrand >> is exploring ways to avoid so many interrupts. I guess the unavoidable >> question is whether this work is still worthwhile given that improvement. > > The way the instrumentation in [0] dealt with interrupts was too complex, > which is why it seemed better to handle the restart the remainder of the > sleep in the sleep function Can you elaborate on how it is too complex? -- nathan