Horton

Re: SUBTRANS: Minimizing calls to SubTransSetParent()

Japin Li <japinli@hotmail.com>

View thread View on postgr.es
From: Japin Li <japinli@hotmail.com>
To: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: Julien Tachoires <julmon@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, pgsql-hackers@lists.postgresql.org
Date: 2022-11-15T13:31:14Z
Lists: pgsql-hackers 
On Tue, 15 Nov 2022 at 17:34, Simon Riggs <simon.riggs@enterprisedb.com> wrote:
> On Mon, 7 Nov 2022 at 21:14, Simon Riggs <simon.riggs@enterprisedb.com> wrote:
>
>> These results are compelling, thank you.
>>
>> Setting this to Ready for Committer.
>
> New version attached.

Take a quick look, I think it should be PGPROC instead of PG_PROC, right?

+		 * 1. When there's no room in PG_PROC, as mentioned above.
+		 *    During XactLockTableWait() we sometimes need to know the topxid.
+		 *    If there is room in PG_PROC we can get a subxid's topxid direct
+		 *    from the procarray if the topxid is still running, using

-- 
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.

Commits

  1. Used optimized linear search in more code paths

  2. Add subxid-overflow "isolation" test