Re: [PERFORM] Extremely slow server?

2013-09-14 Thread bricklen
On Sat, Sep 14, 2013 at 6:54 PM, Craig James wrote: > On Sat, Sep 14, 2013 at 11:36 AM, bricklen wrote: > >> On Sat, Sep 14, 2013 at 11:28 AM, Craig James wrote: >> >>> I'm trying to do a pg_dump of a database, and it more-or-less just sits >>> there doing nothing. >>> >> >> What is running in t

Re: [PERFORM] Extremely slow server?

2013-09-14 Thread Craig James
On Sat, Sep 14, 2013 at 11:36 AM, bricklen wrote: > On Sat, Sep 14, 2013 at 11:28 AM, Craig James wrote: > >> I'm trying to do a pg_dump of a database, and it more-or-less just sits >> there doing nothing. >> > > What is running in the db? Perhaps there is something blocking the > pg_dump? What d

Re: [PERFORM] Extremely slow server?

2013-09-14 Thread bricklen
On Sat, Sep 14, 2013 at 11:28 AM, Craig James wrote: > I'm trying to do a pg_dump of a database, and it more-or-less just sits > there doing nothing. > What is running in the db? Perhaps there is something blocking the pg_dump? What does the output of the following query look like? select * fro

[PERFORM] Extremely slow server?

2013-09-14 Thread Craig James
I'm trying to do a pg_dump of a database, and it more-or-less just sits there doing nothing. "vmstat 2" looked like this during pg_dump: procs ---memory-- ---swap-- -io -system-- cpu r b swpdfree buff cachesi sobibo in cs us sy id wa