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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance