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 1uuTwr-00Ag8J-EJ for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Sep 2025 10:45:42 +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 1uuTwq-006dzA-FM for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Sep 2025 10:45:40 +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 1uuTwq-006dz2-6O for pgsql-hackers@lists.postgresql.org; Fri, 05 Sep 2025 10:45:40 +0000 Received: from mail-pf1-x432.google.com ([2607:f8b0:4864:20::432]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uuTwp-000fGz-0K for pgsql-hackers@postgresql.org; Fri, 05 Sep 2025 10:45:39 +0000 Received: by mail-pf1-x432.google.com with SMTP id d2e1a72fcca58-77256200f1bso2048785b3a.3 for ; Fri, 05 Sep 2025 03:45:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757069138; x=1757673938; darn=postgresql.org; h=in-reply-to:references:from:subject:cc:to:message-id:date :content-transfer-encoding:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=xyRa8WYoA3oZi2MNMmR47gTofv9BxcQYdHZaW5dy0bk=; b=TxkQLvx58MbxG5pzWIyf7WNVY29X/Jq88Y+71MitUsNwQYodzSd6AwW0aq0yHklgac /gBS0EdsG0sZZ6QFAbz4I0f106s1uHqGugz+xTutlubtRGq9/jDliK8v2ZNFEGMZf3Bl 7Tc+k2ZYL3OZ21SHfBOJS6uPbo6mH1Sl1WH9UaJYBA/olKDFavpTpD4JyWGmQGi6CFf6 RT2d7Iqxp0lPKKdB7nIUIYkKWzNQwIZiL/y42IpYHnA7uFkw+t0fPRZjzXdhf/lPL9JV DsRwkAdJBIEYdIAl39K7PR8qy1wuVcD/p7EklFuMoimiIUO0O0F3tWQl/SHnd3uZPXnv vhhQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757069138; x=1757673938; h=in-reply-to:references:from:subject:cc:to:message-id:date :content-transfer-encoding:mime-version:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=xyRa8WYoA3oZi2MNMmR47gTofv9BxcQYdHZaW5dy0bk=; b=QA9wWB3QbfO2ZQLrslJj4qJEYzzVHl2d6dwQSgKDM+GgdGMtsy2SoiCQI57GOSK00m sOu0kMwSqfDh+Movyol3OZIZ5PC/ganA4GIlvfJpm6jPLbtJ1E4nPSfOFbzwrP9sxJmq A3bfZTgCxq0CBYJX2yVVGcvNBhPBhDL5QG5uFNkPUOnlVfmrkqCvioR4Y1TMmN3lHPRr I16p88zo6NyuFN6U+UGCpkXfgqdzfSrOb+Ek5h2MHxFf3aEUsDwR9TmE3qB0eELIhbeD GzJg1weOITr9I6++kQjG/88DtSz+OSQmptB0IMIjj06u7ykfNED2A2LzU3uo/TsF1QSS Z8qw== X-Forwarded-Encrypted: i=1; AJvYcCUPmiwPldSgHATA/Wu8ywbixlthzcRsu6NhXFd85QFWvUmPNr+ykuE+CbOCaRd/PK1KlmzFYgm2meIqLlTG@postgresql.org X-Gm-Message-State: AOJu0YztGBKdYSEkH07+tGg1KnX5fGkNl0vIDBrR10+q/byitUmBI0j1 i66Df9xiTQ1dIzKfbVgX6I+NysNxJMpPvgrOXSNcNbLkpXAIcpz+1//U X-Gm-Gg: ASbGncu9APJUX5mboZbe8MIdcv5MIXJJ7omWzFbeIEj+ITbB7bht0gZafKRfIm2UmNW 2JB4+u917BtVcV2RlGXvvJ0mklL3o6uHfnMOzcavtNFPFum1iutR/vWV1yeN3rfO4G+QlnI/ASo mdkAuF15uY0BshudEAIo53GBSlW2tjXuH6FDofy4vpjVtg4RQnzNmedyNTxVaB8TnffvsclgYsE 5lY+PldKSGIG1uRv4bAqpV240QFjvyz4hknIgZHBxAi7lORbN8hEO8Fv8RfGUWj+J6DdFRCkkZk ue3s+gapEbppJeXWz9ZP2jg+8XNI9lHCVxAqSaypcT3JJnJJY9CY0zsyHcCVT6YQkOJgNz5M7rX iKNKnkNlkD3ERI+mLmy7uNpyw6GNkehkmTSrNE7ejpO+uYUfwS/qpds1kWiw= X-Google-Smtp-Source: AGHT+IEshanngW8HruOUmHpyxT95AYWXzaK+/X7Ta3/bgJPnxt2l6lPbxAKz8FhEFsIbMeoOBU4V/Q== X-Received: by 2002:a05:6a00:2306:b0:748:eedb:902a with SMTP id d2e1a72fcca58-7723e362814mr28741804b3a.17.1757069137905; Fri, 05 Sep 2025 03:45:37 -0700 (PDT) Received: from localhost ([163.116.233.149]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7722a4bcd09sm21161360b3a.49.2025.09.05.03.45.34 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 05 Sep 2025 03:45:37 -0700 (PDT) Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=UTF-8 Date: Fri, 05 Sep 2025 07:45:32 -0300 Message-Id: To: "Rishu Bagga" , "Arseniy Mukhin" Cc: "Yura Sokolov" , "Masahiko Sawada" , "Daniil Davydov" <3danissimo@gmail.com>, =?utf-8?q?=C3=81lvaro_Herrera?= , "Alexandra Wang" , "PostgreSQL Hackers" , "Tom Lane" , "Joel Jacobson" Subject: Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue From: "Matheus Alcantara" X-Mailer: aerc 0.20.1 References: <202508061044.ptcyt7aqsaaa@alvherre.pgsql> In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu Sep 4, 2025 at 8:02 PM -03, Rishu Bagga wrote: > On Thu, Sep 4, 2025 at 7:14=E2=80=AFAM Arseniy Mukhin > wrote: > >> Interesting, have you shared your patch and results somewhere? IIUC >> Tom's approach resolves this bug, because with it we have queue >> entries produced by committed transactions only, so we don't need to >> check their status and don't have dependency on clog. > > I was eventually able to get better numbers with the patch after using > a substantial number of connections, so I have now posted it here. [1]. > Thanks for sharing the patch! I'll reserve some time to test and review. -- Matheus Alcantara