Re: [PERFORM] Suspicious top output

2008-04-22 Thread Greg Smith
On Tue, 22 Apr 2008, Rafael Barrera Oro wrote: Hello, i have a postgresql server running and from time to time it gets painfully slow. The usual information you should always include when posting messages here is PostgreSQL and operating system versions. When this happens i usually connect

Re: [PERFORM] Suspicious top output

2008-04-22 Thread Ivan Voras
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 pgsql1 40 48552K 42836K sb

[PERFORM] Suspicious top output

2008-04-22 Thread Rafael Barrera Oro
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 pgsql1 40 48552K 42836K sbwait 1:41 4.79% postgres