Re: Copy to Csv file extremely slow - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Copy to Csv file extremely slow
Date
Msg-id CAHyXU0zMfoQwMiFTyEnt3HGjx9Laba4rJog6bg3XfOqRsPn_jA@mail.gmail.com
Whole thread Raw
In response to Re: Copy to Csv file extremely slow  (Jalisson Mello <jalissonmeneses@hotmail.com>)
List pgsql-novice
On Thu, May 30, 2013 at 6:43 PM, Jalisson Mello
<jalissonmeneses@hotmail.com> wrote:
> Thanks by the answer.
>
> The iowait is very low i think, it's varies between 0.14 and 1.1  and cpu
> 98% idle during this time.
>
> OS and hardware problems were the first things that i thought and tested and
> until now nothing strange.
>
>  It's writing to local disk.
>
>  Any suggestion or idea will be welcome.
>
> Tomorrow I will post my postgresql.conf  because today is holiday here in
> Brazil and I don't have acess to the servers from my home.

What I would try next is to see if if the copying process is binding
up in a system call:  try strace -t on the process that is doing the
dump.  If you see excessive timings there that will be a big clue.

merlin


pgsql-novice by date:

Previous
From: Frank Moore
Date:
Subject: Fwd: No connection could be made because the target machine actively refused it...
Next
From: Christian Lawrence
Date:
Subject: permissions, exclusive row locks, and delete