Re: Extremely slow server?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: Craig James <cjames(at)emolecules(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Extremely slow server?
Date: 2013-09-15 20:55:45
Message-ID: CAMkU=1wzKV9CkFPVSH8qS0DGaG-rNeL2bfN-Q_9zN16+h+OEYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Sep 14, 2013 at 7:06 PM, bricklen <bricklen(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2013-09-16 00:18:44 Re: COPY TO and VACUUM
Previous Message Vitalii Tymchyshyn 2013-09-15 07:50:40 Re: Extremely slow server?