| From: | Ivan Voras <ivoras(at)geri(dot)cc(dot)fer(dot)hr> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Suspicious top output |
| Date: | 2008-04-22 23:50:33 |
| Message-ID: | fultkb$r9k$1@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Voras | 2008-04-22 23:58:47 | Re: CPU bound at 99% |
| Previous Message | Tom Lane | 2008-04-22 21:55:23 | Re: [PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536" |