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.pezzatti@wsl.ch>
To: Francisco Leovey <fleovey@yahoo.com>
Cc: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.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.pezzatti@wsl.ch>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgadmin-support@postgresql.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@postgresql.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.pezzatti@wsl.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.pezzatti@wsl.ch http://www.wsl.ch