Re: very slow when writing query to file

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