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
