Re: very slow when writing query to file

Actually I do not have access to the server file system.
What I can not understand is that:
1) if I can execute the query and see the data in the table viewer the
data are also sent over the network
2) how does the execute to file command differ with respect to the point
1) ? Is each line retrieved separately and written to the file
location? Or is written first to a temporary location and then copied?

Maybe I'll have to start looking into the source code ....
Thanks anyway,

Boris

On 10/31/2011 12:54 PM, Francisco Leovey wrote:
> I propose you output to a file located on the same server as the DB
> and then copy that file to your PC
> IMO your problem is network related.
>
> *From:* boris pezzatti <boris(dot)pezzatti(at)wsl(dot)ch>
> *To:* Francisco Leovey <fleovey(at)yahoo(dot)com>
> *Cc:* "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
> *Sent:* Sunday, October 30, 2011 6:28 PM
> *Subject:* Re: [pgadmin-support] very slow when writing query to file
> No, actually it is on my machine ... On 10/29/2011 11:01 PM, Francisco
> Leovey wrote:
>> Is the file where you write the query output located on the same
>> server as the DB?
>>
>> *From:* boris pezzatti <boris(dot)pezzatti(at)wsl(dot)ch>
>> <mailto:boris(dot)pezzatti(at)wsl(dot)ch>
>> *To:* Guillaume Lelarge <guillaume(at)lelarge(dot)info>
>> <mailto:guillaume(at)lelarge(dot)info>
>> *Cc:* pgadmin-support(at)postgresql(dot)org
>> <mailto:pgadmin-support(at)postgresql(dot)org>
>> *Sent:* Saturday, October 29, 2011 5:44 PM
>> *Subject:* Re: [pgadmin-support] very slow when writing query to file
>> Does anyone have any proposition how I could further test where the
>> problem is. This is really a strange behaviour, that I noticed with
>> different versions of pgAdmin. Could a firewall produce a difference
>> when querying data visually or for a write to file? (should not ...)
>> Thank you, Boris Guillaume Lelarge wrote: > 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. > > -- Sent via
>> pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org
>> <mailto:pgadmin-support(at)postgresql(dot)org>) To make changes to your
>> subscription: http://www.postgresql.org/mailpref/pgadmin-support
> -- *Boris Pezzatti
> Swiss Federal Research Institute WSL
> *
> Research unit Community Ecology
> Team Insubric Ecosystems
> via Belsoggiorno 22
> CH-6500 Bellinzona
> Switzerland phone direct ++41 91 821 52 32
> phone ++41 91 821 52 30
> fax ++41 91 821 52 39
> boris(dot)pezzatti(at)wsl(dot)ch <mailto:boris(dot)pezzatti(at)wsl(dot)ch>
> http://www.wsl.ch/
>

--
*Boris Pezzatti
Swiss Federal Research Institute WSL
*
Research unit Community Ecology
Team Insubric Ecosystems
via Belsoggiorno 22
CH-6500 Bellinzona
Switzerland phone direct ++41 91 821 52 32
phone ++41 91 821 52 30
fax ++41 91 821 52 39
boris(dot)pezzatti(at)wsl(dot)ch
http://www.wsl.ch <http://www.wsl.ch/>