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?