Re: Suspicious top output

Rafael Barrera Oro wrote:
> Hello, i have a postgresql server running and from time to time it gets
> painfully slow. When this happens i usually connect to the server and
> run a "top" command, the output i get is filled with lines like the
> following
> 
> 71872 pgsql            1   4    0 48552K 42836K sbwait   1:41  4.79%
> postgres
> 
> Are those connections that were not closed or something like that?

This looks like FreeBSD; "sbwait" state is socket buffer wait, and 
guessing from the CPU usage the process seems to be talking to another 
process.

> should i worry?

Don't know. Are you sure all client processes disconnect properly from 
the database?


-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance