~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
>

Reply via email to