| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Jalisson Mello <jalissonmeneses(at)hotmail(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Copy to Csv file extremely slow |
| Date: | 2013-05-31 20:40:41 |
| Message-ID: | CAHyXU0zMfoQwMiFTyEnt3HGjx9Laba4rJog6bg3XfOqRsPn_jA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, May 30, 2013 at 6:43 PM, Jalisson Mello
<jalissonmeneses(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Lawrence | 2013-06-03 23:35:00 | permissions, exclusive row locks, and delete |
| Previous Message | Frank Moore | 2013-05-31 19:59:29 | Fwd: No connection could be made because the target machine actively refused it... |