Re: very slow when writing query to file

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: boris pezzatti <boris(dot)pezzatti(at)wsl(dot)ch>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: very slow when writing query to file
Date: 2011-10-28 17:58:18
Message-ID: 1319824698.2119.5.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Wed, 2011-10-26 at 14:57 +0200, boris pezzatti wrote:
> I have a postgresql database 8.3 on a server. When querying the data
> with the pgAdmin sql editor, I can get an answer in about 10 s, for
> 100'000 rows. When I'm pressing the button to execute the query to a
> file it takes more than 1 hour to get the query results saved (writes
> about 10 MB in 45 minutes).
>
> Am I doing something wrong?
> Are there some parameters to set?
>

Never heard of such a behaviour before. I'm not sure what happens on
your computer.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-10-28 17:59:53 Re: Error when trying to build on Ubunt 11.10
Previous Message Guillaume Lelarge 2011-10-28 17:50:53 Re: SQL Query tool in PGAdmin causing exception