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

From Jeff Janes
Subject Re: Extremely slow server?
Date
Msg-id CAMkU=1wzKV9CkFPVSH8qS0DGaG-rNeL2bfN-Q_9zN16+h+OEYg@mail.gmail.com
Whole thread Raw
In response to Re: Extremely slow server?  (bricklen <bricklen@gmail.com>)
List pgsql-performance
On Sat, Sep 14, 2013 at 7:06 PM, bricklen <bricklen@gmail.com> wrote:


I don't have any solutions at the moment, but three things come to mind:

1). Try without "--blobs",
2). Does "strace -p <pid of pg_dump process>" show anything unusual? Futex? Lots of semops?

He probably needs to find the pid of the backend to which pg_dump is connected (such as from pg_stat_activity), and strace that rather than stracing pg_dump itself.

Cheers,

Jeff

pgsql-performance by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Extremely slow server?
Next
From: Jeff Janes
Date:
Subject: Re: COPY TO and VACUUM