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
