Home > mailing lists

Re: Extremely slow server? - Mailing list pgsql-performance

From	bricklen
Subject	Re: Extremely slow server?
Date	September 14, 2013 18:36:14
Msg-id	CAGrpgQ9HJ5Mj8kCErhudxd3Kc7tHj6Dr6a=rximT5UGchA=tGg@mail.gmail.com Whole thread Raw
In response to	Extremely slow server? (Craig James <cjames@emolecules.com>)
Responses	Re: Extremely slow server?
List	pgsql-performance

On Sat, Sep 14, 2013 at 11:28 AM, Craig James <cjames@emolecules.com> 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 * from pg_stat_activity where pid <> pg_backend_pid()

From: Craig James
Date: 14 September 2013, 18:28:42
Subject: Extremely slow server?

From: Craig James
Date: 15 September 2013, 01:54:31
Subject: Re: Extremely slow server?