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 1rNlbT-00FRUY-Ah for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Jan 2024 03:19:35 +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 1rNlbS-008taL-EE for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Jan 2024 03:19:34 +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 1rNlbS-008taA-5O for pgsql-hackers@lists.postgresql.org; Thu, 11 Jan 2024 03:19:34 +0000 Received: from m15.mail.163.com ([45.254.50.220]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rNlbI-000wVR-RE for pgsql-hackers@lists.postgresql.org; Thu, 11 Jan 2024 03:19:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=From:Subject:Date:Message-ID:MIME-Version: Content-Type; bh=ZSGLFN5mS9G82hDHavzwVrJlM91vP3Pn6tHbEHSrgOQ=; b=SMCu0yMSTvjsmS3liJpbsEzdlm+du96u40AfcbDj15w68CCPzgnRNTMdOU62cT 8h2no7hIBf4eO1HW9cG49W25ehsptSlExiF9wCHWbWgb4pz3pIy2UEoQSb20Zs+Z 3L4ts0Ut2JHp1z7JgNQC0rU4kPRtF/RGff0eJd3i15SDA= Received: from b97369165980 (unknown [140.205.118.47]) by zwqz-smtp-mta-g1-2 (Coremail) with SMTP id _____wDnb00uXp9llSlOAw--.14168S3; Thu, 11 Jan 2024 11:19:11 +0800 (CST) References: <87plyhvama.fsf@163.com> <489987.1704381735@sss.pgh.pa.us> <498328.1704386013@sss.pgh.pa.us> <20240104225403.dgmbbfffmm3srpgq@awork3.anarazel.de> <871qaso7ub.fsf@163.com> <87sf37mdqq.fsf@163.com> <87o7dum084.fsf@163.com> User-agent: mu4e 1.10.7; emacs 29.1 From: Andy Fan To: Robert Haas Cc: Matthias van de Meent , Andres Freund , Tom Lane , Thomas Munro , pgsql-hackers@lists.postgresql.org Subject: Re: the s_lock_stuck on perform_spin_delay Date: Thu, 11 Jan 2024 11:17:52 +0800 In-reply-to: Message-ID: <87cyu8mua9.fsf@163.com> MIME-Version: 1.0 Content-Type: text/plain X-CM-TRANSID: _____wDnb00uXp9llSlOAw--.14168S3 X-Coremail-Antispam: 1Uf129KBjDUn29KB7ZKAUJUUUUU529EdanIXcx71UUUUU7v73 VFW2AGmfu7bjvjm3AaLaJ3UbIYCTnIWIevJa73UjIFyTuYvjxUU0edUUUUU X-Originating-IP: [140.205.118.47] X-CM-SenderInfo: x2klx3xlid0iqsrtqiywtou0bp/xtbBzxRiU2V4HShNkQAAse List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Robert Haas writes: > Thanks for jumping in with a review, Matthias! FWIW, Matthias is also the first one for this proposal at this thread, thanks for that as well! -- Best Regards Andy Fan