Re: Copy to Csv file extremely slow

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