in it,
and I cannot estimate how much time it would take.
> -Original Messages-
> From: "Kevin Grittner" <kgri...@gmail.com>
> Sent Time: 2017-03-28 00:16:11 (Tuesday)
> To: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.cn>
> Cc: "pgsql-h
tner" <kgri...@gmail.com>
> Sent Time: 2017-03-25 04:53:36 (Saturday)
> To: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.cn>
> Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] Guidelines for GSoC student
> -Original Messages-
> From: "Kevin Grittner" <kgri...@gmail.com>
> Sent Time: 2017-03-15 23:20:07 (Wednesday)
> To: DEV_OPS <dev...@ww-it.cn>
> Cc: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.cn>,
> "pgsql-hackers@postgresq
sal, not ready-to-go proposal documents.
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
--
Mengxing Liu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ared memory issues, since the structure *must*
> live in shared memory.
>
Thank you. If there is no other problem, I will submit the proposal.
--
Mengxing Liu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ement.
For me, the challenge is profiling the execution. Is there any tools in
PostgreSQL to analysis where is the CPU cycles consumed?
Or I have to instrument and time by myself?
Regards.
--
Mengxing Liu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
> -Original Messages-
> From: "Kevin Grittner" <kgri...@gmail.com>
> Sent Time: 2017-03-12 04:24:29 (Sunday)
> To: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.cn>
> Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql
Hi George,
I am Mengxing Liu. Happy to meet someone with the same idea : )
I have been concentrating on it for a long time, reading papers, reading source
codes, and discussing details with Mr Grittner. So I really understand your
passion on it. But definitely I don't want all these effects
Hi, all
My name is Mengxing Liu. I am interested in the project "Eliminate O(N^2)
scaling from rw-conflict tracking in serializable transactions”. After
discussing with Kevin off-list, I think it's time to post discussion here. I am
afraid that there are two things that I need your
nce.
It's hard to explain why...
You can reply directly if you have any questions or comments.
--
Sincerely
Mengxing Liu
HTAB-for-conflict-tracking.patch
Description: Binary data
skip-list-for-conflict-tracking.patch
Description: Binary data
reduce-content
me implementations. What's your opinion?
> --
> Álvaro Herrerahttps://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sincerely
Mengxing Liu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
list is
enough now.
I'll make a clean patch after I figure out bugs.
--
Sincerely
Mengxing Liu
.
To focus on this issue, I removed other parts of modification.
Do you have any advices for this ?
--
Sincerely
Mengxing Liu
finishedlock.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
for conflict tracking.
2) reducing the global lock contention
3) using skip list for conflict tracking.
But all of them did not improve the performance. So I'm a little confused now
about what to do next.
Could you please give me any suggestions?
--
Sincerely
Mengxing Liu
skip-list
means, the skip list can work!
Looking forward to your advices.
--
Sincerely
Mengxing Liu
skip-list-for-conflict-tracking.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
.
But I'm really looking forward to your advice for my proposal. We can't be too
careful to modify the code related to locks.
--
Sincerely
Mengxing Liu
ed by some
mistakes.
When I changed a machine to run the code, this phenomenon didn't happen
anymore..
-Original Messages-
From: "Robert Haas" <robertmh...@gmail.com>
Sent Time: 2017-07-29 02:46:47 (Saturday)
To: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.c
RWConflictExists/SetRWConflict is as below.
| | RWConflictExists | SetRWConflict |
| linked list | 1.39% | 0.14% |
| skip list | 1.15% | 0.35% |
According to the suggestions of Alvaro, I'll give a detailed performance
report tomorrow.
--
Sincerely
Mengxing Liu
skip-list-for-conflict
> --
> Álvaro Herrerahttps://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sincerely
Mengxing Liu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
and the performance can't be improved. A chart is
attached. This optimization
can achieve 14% speedup at most.
Do you think this optimization can be accepted?
--
Sincerely
Mengxing Liu
skip-list-for-conflict-tracking.patch
Description: Binary data
--
Sent via pgsql-hackers mailing
s once a week?
> What steps will be taken next during the community bonding period.
As I wrote in the proposal, I want to establish the environment and read the
related source code. Do you have any suggestions for me?
--
Mengxing Liu
ms to go to lightweight locking. Since
> you said this is a CPU graph, that again suggests spinlock contention
> issues.
>
> --
Yes. Is there any other kind of locks besides spinlock? I'm reading locks in PG
now. If all locks are spinlock, the CPU should be used 100%. But now only 50%
think that's why PG is so slow in high contention environment.
> -Original Messages-
> From: "Robert Haas" <robertmh...@gmail.com>
> Sent Time: 2017-06-08 01:30:58 (Thursday)
> To: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.cn>
> Cc: kgrit
ause hash table objects also consume memory )
But just for performance, it would be less efficient than my patch.
Because it has to maintain linked lists, besides hash tables. In other words,
it does more works than my patch.
Another point is that removing linked list may have more opportunit
ny chance to get rid of this problem?
BTW, I found that the email is not very convenient, especially when I have
some problem and want to discuss with you.
Would you mind scheduling a meeting every week by Skye, or other instant
message software you like?
I would not take you too much time. Ma
> -Original Messages-
> From: "Kevin Grittner" <kgri...@gmail.com>
> Sent Time: 2017-06-03 01:44:16 (Saturday)
> To: "Alvaro Herrera" <alvhe...@2ndquadrant.com>
> Cc: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.cn>,
,
PreCommit_CheckForSerializationFailure
Sincerely
--
Mengxing Liu
ot; to profile is really ugly.
Perf lock can only record kernel mutex, and requires kernel support, so I
didn't use it.
Do you have any good idea about profiling time waiting for locks?
> -Original Messages-
> From: "Mengxing Liu" <liu-m...@mails.tsinghua.edu.cn>
> S
28 matches
Mail list logo