Re: Finding bottleneck

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Kari Lavikka" <tuner(at)bdb(dot)fi>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Finding bottleneck
Date: 2005-07-28 18:27:36
Message-ID: BF0E71A8.A2AF%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 7/28/05 2:21 AM, "Kari Lavikka" <tuner(at)bdb(dot)fi> wrote:

There's a new profiling tool called oprofile:

http://oprofile.sourceforge.net/download/

that can be run without instrumenting the binaries beforehand. To actually
find out what the code is doing during these stalls, oprofile can show you
in which routines the CPU is spending time when you start/stop the
profiling.

As an alternative to the "guess->change parameters->repeat" approach, this
is the most direct way to find the exact nature of the problem.

- Luke

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-07-28 21:57:10 Re: wal_buffer tests in
Previous Message Tom Lane 2005-07-28 18:19:28 Re: Unable to explain DB error