Re: very slow when writing query to file - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: very slow when writing query to file
Date
Msg-id 1320269199.2145.30.camel@localhost.localdomain
Whole thread Raw
In response to Re: very slow when writing query to file  (boris pezzatti <boris.pezzatti@wsl.ch>)
List pgadmin-support
On Wed, 2011-11-02 at 09:21 +0100, boris pezzatti wrote:
> ... or (I promise this is the last guess)  each row is appended to the 
> file in the the loop, and on some OS's there is a problem keeping open 
> the file (so that each time the file must be opened again ...  adding a 
> lot of extra time). Maybe creating all the "virtual file" in a variable 
> and storing all at once (or let say in chunks of 100 Mb) could solve the 
> problem ...
> 

Tried that yesterday, wasn't much faster (two seconds less, which isn't
much).


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



pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: very slow when writing query to file
Next
From: Guillaume Lelarge
Date:
Subject: Re: Bug, New Column... window, data type typing