6602.635 ms (00:06.603)
Thanks
Pengcheng
-Original Message-
From: Andrey Borodin
Sent: 2021年9月3日 14:51
To: Pengchengliu
Cc: pgsql-hack...@postgresql.org
Subject: Re: suboverflowed subtransactions concurrency performance optimize
Sorry, for some reason Mail.app converted message to html
/34/2627/
[1]
https://www.postgresql.org/message-id/flat/20180814213500.GA74618%4060f81dc409fc.ant.amazon.com
Thanks
Pengcheng
-Original Message-
From: Andrey Borodin
Sent: 2021年8月30日 18:25
To: Pengchengliu
Cc: pgsql-hack...@postgresql.org
Subject: Re: suboverflowed subtransacti
Hi hackers,
I wrote a patch to resolve the subtransactions concurrency performance
problems when suboverflowed.
When we use more than PGPROC_MAX_CACHED_SUBXIDS(64) subtransactions per
transaction concurrency, it will lead to subtransactions performance
problems.
All backend will be stuck at acqui
--Original Message-
From: Greg Nancarrow
Sent: 2021年5月18日 17:15
To: Pengchengliu
Cc: Andres Freund ; PostgreSQL-development
Subject: Re: Re: Parallel scan with SubTransGetTopmostTransaction assert
coredump
On Tue, May 18, 2021 at 11:27 AM Pengchengliu wrote:
>
> Hi Greg,
>
>
Hi Greg,
> I actually think that the Assert in SubTransGetTopmostTransaction() is
correct, but in the parallel-worker case, the snapshots are not being setup
correctly.
I agree with you that Assert in SubTransGetTopmostTransaction() is correct.
The root cause is Transaction Xmin are not
with-SubTransGetTopmostTransaction-assert-coredump-td6197408.html
Thanks
Pengcheng
-Original Message-
From: Greg Nancarrow
Sent: 2021年5月15日 0:44
To: Pengchengliu
Cc: Andres Freund ; PostgreSQL-development
Subject: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump
On Fri, May 14,
sue should still exist.
Thanks
Pengcheng
-Original Message-
From: Greg Nancarrow
Sent: 2021年5月14日 16:47
To: Pengchengliu
Cc: Andres Freund ; PostgreSQL-development
Subject: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump
On Fri, May 14, 2021 at
, active_count = 1,
regd_count = 2, ph_node = {first_child = 0x0, next_sibling = 0x0,
prev_or_parent = 0x2d52e48}, whenTaken = 0, lsn = 0}
(gdb)
Thanks
Pengcheng
-Original Message-
From: Greg Nancarrow
Sent: 2021年5月13日 22:15
To: Pengchengliu
Cc: Andres Freund ; PostgreSQL-dev
--Original Message-
From: Greg Nancarrow
Sent: 2021年5月11日 19:08
To: Pengchengliu
Cc: Andres Freund ; PostgreSQL-development
Subject: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump
On Tue, May 11, 2021 at 11:28 AM Pengchengliu <
<mailto:pengcheng...@tju.edu.
al Message-
From: Andres Freund
Sent: 2021年5月7日 11:55
To: Pengchengliu
Cc: pgsql-hack...@postgresql.org
Subject: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump
Hi,
On 2021-05-07 11:32:57 +0800, Pengchengliu wrote:
> Hi Hackers，
>
> Last email, format error, missi
al Message-
From: Andres Freund
Sent: 2021年5月7日 11:55
To: Pengchengliu
Cc: pgsql-hack...@postgresql.org
Subject: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump
Hi,
On 2021-05-07 11:32:57 +0800, Pengchengliu wrote:
> Hi Hackers，
>
> Last email, format error, missi
Hi Hackers，
Last email, format error, missing some information, so I resend this email.
With PG 13.2(3fb4c75e857adee3da4386e947ba58a75f3e74b7), I tested
subtransaction with parallel scan, I got a subtransaction coredump as below:
```
(gdb) bt
#0 0x1517ce61f7ff in raise () from /lib
Hi hackers,
With PG 13.2(3fb4c75e857adee3da4386e947ba58a75f3e74b7), I tested
subtransaction with parallel scan, I got a subtransaction coredump as below:
(gdb) bt
#0 0x1517ce61f7ff in raise () from /lib64/libc.so.6
#1 0x1517ce609c35 in abort () from /lib64/libc.so.6
#2 0x00aa
13 matches
Mail list logo
