Re: Finding bottleneck - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Finding bottleneck
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD026@Herge.rcsinc.local
Whole thread Raw
In response to Finding bottleneck  (Kari Lavikka <tuner@bdb.fi>)
Responses Re: Finding bottleneck  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Finding bottleneck  (Kari Lavikka <tuner@bdb.fi>)
List pgsql-performance
> Kari Lavikka <tuner@bdb.fi> writes:
> > samples  %        symbol name
> > 13513390 16.0074  AtEOXact_CatCache
>
> That seems quite odd --- I'm not used to seeing that function at the
top
> of a profile.  What is the workload being profiled, exactly?

He is running a commit_delay of 80000.  Could that be playing a role?

Merlin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow update statement
Next
From: Tom Lane
Date:
Subject: Re: Finding bottleneck