From: Greg Smith <gsmith@gregsmith.com>
To: Rafael Barrera Oro <rafael@akyasociados.com.ar>
Cc: pgsql-performance@postgresql.org
Subject: Re: Suspicious top output
Date: Wed, 23 Apr 2008 01:43:27 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0804230138310.22837@westnet.com> (raw)
In-Reply-To: <480E2FBE.3010607@akyasociados.com.ar>
References: <480E2FBE.3010607@akyasociados.com.ar>
On Tue, 22 Apr 2008, Rafael Barrera Oro wrote:
> Hello, i have a postgresql server running and from time to time it gets
> painfully slow.
The usual information you should always include when posting messages here
is PostgreSQL and operating system versions.
> When this happens i usually connect to the server and run a "top"
> command
The other thing you should fire up in another window is "vmstat 1" to
figure out just what's going on in general. The great thing about those
is you can save them when you're done and easily analyze the results later
easily, which is trickier to do with top.
> 71872 pgsql 1 4 0 48552K 42836K sbwait 1:41 4.79%
> postgres
Some searching found this interesting suggestion from Darcy about things
stuck in sbwait:
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2004-03/0015.html
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com, rafael@akyasociados.com.ar
Subject: Re: Suspicious top output
In-Reply-To: <Pine.GSO.4.64.0804230138310.22837@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox