| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | "Anand Kumar, Karthik" <Karthik(dot)AnandKumar(at)classmates(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Repeated semop calls |
| Date: | 2014-06-27 18:43:53 |
| Message-ID: | 20140627184353.GI18288@awork2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2014-06-27 10:51:20 -0700, Jeff Janes wrote:
> On Thu, Jun 26, 2014 at 1:03 PM, Anand Kumar, Karthik
> > Samples: 33K of event 'cycles', Event count (approx.): 20693251070
> > 26.16% postmaster postgres [.] 0x0000000000188450
> > 21.13% postmaster postgres [.] hash_search_with_hash_value
> > 10.47% postmaster postgres [.] heap_page_prune_opt
> > 4.21% postmaster postgres [.] LWLockAcquire
> > 3.71% postmaster postgres [.] slot_getattr
> > 1.97% postmaster postgres [.] HeapTupleSatisfiesMVCC
>
> If it is what I am guessing at, then the top anonymous address is
> probably coming from LWLockAcquire, and those are coming from
> HeapTupleSatisfiesMVCC. I don't know how to verify that, though.
Recompile postgres with -fno-omit-frame-pointers and use perf record -g.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anand Kumar, Karthik | 2014-06-27 20:05:36 | Re: Repeated semop calls |
| Previous Message | Jeff Janes | 2014-06-27 17:51:20 | Re: Repeated semop calls |