In XidInMVCCSnapshot, it will check xid from tuple if is in snapshot->subxip.
It means tuple store subtransaction?
But in PushTransaction, I see TransactionState.subTransaction will assign
currentSubTransactionId, currentSubTransactionId will reinitialize in
StartTransaction. So I think tuple s
Test configuration:
Hardware:
4P intel server, 60 core 120 hard thread.
Memory:512G
SSD:2.4T
PG:
max_connections = 160 # (change requires restart)
shared_buffers = 32GB
work_mem = 128MB
maintenance_work_me
I use benchmarksql with more than 200 clients on pg 9.3.3. when the test is
going on, I collect all the process stack. I found about 100 processes are
blocked by btree insert. Another 100 are blocked by xloginsert.
Does btree has bad performance in concurrency scenarios?
Sum:66
#0 0x7f8273
0.73% postgres postgres [.] heap_hot_search_buffer
>From: Amit Kapila [mailto:amit.kapil...@gmail.com]
>Sent: Tuesday, September 02, 2014 10:44 PM
>To: Xiaoyulei
>Cc: pgsql-hackers@postgresql.org
>Subject: Re: 答复: [HACKERS] why after increase the hash table
>pa
: Xiaoyulei
抄送: pgsql-hackers@postgresql.org
主题: Re: [HACKERS] why after increase the hash table partitions, TPMC decrease
On Tue, Sep 2, 2014 at 2:09 PM, Xiaoyulei
mailto:xiaoyu...@huawei.com>> wrote:
>
>
>
> We use benchmarksql to start tpcc test in postgresql 9.3.3.
>
> Before
We use benchmarksql to start tpcc test in postgresql 9.3.3.
Before test we set benchmarksql client number about 800. And we increase the
hash partitions from 16 to 1024 , in order to reduce the hash partition locks
competition.
We expect that after increase the number of partitions, reduces lock