Re: very slow when writing query to file

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: very slow when writing query to file
Дата
Msg-id 1320269199.2145.30.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: very slow when writing query to file  (boris pezzatti <boris.pezzatti@wsl.ch>)
Список 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 по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: very slow when writing query to file
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Bug, New Column... window, data type typing