Mengxing Liu wrote: > Hi, Alvaro and Kevin. > > > Anyway, this is just my analysis. > > So I want to hack the PG and count the conflict lists' size of > > transactions. That would be more accurate. > > In the last week, I hacked the PG to add an additional thread to count > RWConflict list lengths. > And tune the benchmark to get more conflict. But the result is still not good.
Kevin mentioned during PGCon that there's a paper by some group in Sydney that developed a benchmark on which this scalability problem showed up very prominently. I think your first step should be to reproduce their results -- my recollection is that Kevin says you already know that paper, so please dedicate some time to analyze it and reproduce their workload. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers