~20 minutes each run with binary. Try your patch now.. You are right I used -g in perf record. But what I reported was flat (meant as a start).
Expand GetMultiXactIdMembers: 3.82% postgres postgres [.] GetMultiXactIdMembers | |--9.09%-- GetMultiXactIdMembers | |--0.84%-- 0x48fb894853f58948 | | | |--0.74%-- 0x4296e0004296c | | GetMultiXactIdMembers | | | |--0.64%-- 0x52f8d00052f8d | | GetMultiXactIdMembers | | | |--0.64%-- 0xf6ce8000f6ce8 | | GetMultiXactIdMembers | | | |--0.62%-- 0x41de300041de1 | | GetMultiXactIdMembers | | | |--0.61%-- 0xf2c77000f2c71 | | GetMultiXactIdMembers | | | |--0.60%-- 0x3127700031275 | | GetMultiXactIdMembers | | | |--0.59%-- 0x10c98b0010c987 | | GetMultiXactIdMembers | | | |--0.59%-- 0x31df000031df0 | | GetMultiXactIdMembers | | | |--0.59%-- 0xbefbd000befbd | | GetMultiXactIdMembers | | | |--0.58%-- 0xfe97c000fe976 | | GetMultiXactIdMembers | | | |--0.58%-- 0x82501000824f9 | | GetMultiXactIdMembers | | | |--0.58%-- 0x3a4410003a43c | | GetMultiXactIdMembers | | | |--0.58%-- 0x3b0cf0003b0c3 | | GetMultiXactIdMembers | | | |--0.58%-- 0x5325f0005325b | | GetMultiXactIdMembers | | | |--0.58%-- 0x7b6b80007b6b8 | | GetMultiXactIdMembers | | | |--0.57%-- 0x52e9b00052e9b | | GetMultiXactIdMembers | | | |--0.57%-- 0xf3d45000f3d40 | | GetMultiXactIdMembers | | | |--0.57%-- 0x27afd00027afa | | GetMultiXactIdMembers | | | |--0.57%-- 0x3244d0003244d | | GetMultiXactIdMembers | | | |--0.56%-- 0x53e0d00053e06 | | GetMultiXactIdMembers | | | |--0.56%-- 0xb64c6000b64bc | | GetMultiXactIdMembers | | | |--0.56%-- 0x423f1000423ef | | GetMultiXactIdMembers | | | |--0.56%-- 0xc18f2000c18ed | | GetMultiXactIdMembers | | | |--0.56%-- 0x6bdcf0006bdcd | | GetMultiXactIdMembers | | | |--0.55%-- 0xc6d25000c6d25 | | GetMultiXactIdMembers | | | |--0.55%-- 0xf6534000f6534 | | GetMultiXactIdMembers | | | |--0.55%-- 0x10bba80010bba0 | | GetMultiXactIdMembers | | | |--0.55%-- 0xb5a76000b5a6e | | GetMultiXactIdMembers | | | |--0.55%-- 0x2d3c10002d3b5 | | GetMultiXactIdMembers | | | |--0.55%-- 0xcc095000cc095 | | GetMultiXactIdMembers | | | |--0.55%-- 0x2e3340002e334 | | GetMultiXactIdMembers | | | |--0.54%-- 0xafffc000afff9 | | GetMultiXactIdMembers | | | |--0.54%-- 0x68caf00068caf | | GetMultiXactIdMembers | | | |--0.54%-- 0x5ec090005ec09 | | GetMultiXactIdMembers | | | |--0.54%-- 0x51eb100051eac | | GetMultiXactIdMembers | | | |--0.54%-- 0x5402000054020 | | GetMultiXactIdMembers | | | |--0.54%-- 0xe352a000e3526 | | GetMultiXactIdMembers | | | |--0.53%-- 0x6a5d30006a5d3 | | GetMultiXactIdMembers | | | |--0.53%-- 0x2860b00028606 | | GetMultiXactIdMembers | | | |--0.53%-- 0xce9ad000ce9ab | | GetMultiXactIdMembers | | | |--0.53%-- 0x42d4000042d40 | | GetMultiXactIdMembers | | | |--0.53%-- 0x27e6900027e69 | | GetMultiXactIdMembers | | | |--0.53%-- 0x7aaf20007aaef | | GetMultiXactIdMembers | | | |--0.52%-- 0x2b6150002b615 | | GetMultiXactIdMembers | | | |--0.52%-- 0x2969200029692 | | GetMultiXactIdMembers | | | |--0.52%-- 0xc801e000c8016 | | GetMultiXactIdMembers | | | |--0.52%-- 0xc72c5000c72bf | | GetMultiXactIdMembers | | | |--0.52%-- 0xc2018000c2018 | | GetMultiXactIdMembers | | | |--0.51%-- 0x6ad840006ad7b | | GetMultiXactIdMembers | | | |--0.51%-- 0x80b4600080b41 | | GetMultiXactIdMembers | | | |--0.51%-- 0xd627a000d6276 | | GetMultiXactIdMembers | | | |--0.51%-- 0xfafb9000fafb9 | | GetMultiXactIdMembers | | | |--0.50%-- 0xc6b3c000c6b38 | | GetMultiXactIdMembers | | | |--0.50%-- 0x7207700072072 | | GetMultiXactIdMembers | --69.92%-- [...] --90.08%-- [...] Thanks, Dong On Wed, Dec 18, 2013 at 2:17 PM, Andres Freund <and...@2ndquadrant.com>wrote: > Hello, > > On 2013-12-18 10:24:56 -0800, Dong Ye wrote: > > It seems that 0ac5ad5134f2769ccbaefec73844f8504c4d6182 is the culprit > > commit. > > How long does a run take to verify the problem? Could you retry with the > patch attached to > > http://www.postgresql.org/message-id/20131201114514.gg18...@alap2.anarazel.de > ? Based on the theory that it creates many superflous multixacts. > > > Flat perf profiles of two such runs look like: > > Those aren't really flat profiles tho ;) > > > 0ac: > > > > Samples: 706K of event 'cycles', Event count (approx.): 6690377376522 > > > > > > + 3.82% postgres postgres [.] > > GetMultiXactIdMembers > > Could you expland that one some levels, so we see the callers? > > Greetings, > > Andres Freund > > -- > Andres Freund http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >