Re: very slow when writing query to file
От | boris pezzatti |
---|---|
Тема | Re: very slow when writing query to file |
Дата | |
Msg-id | 4EAE9CD9.5010602@wsl.ch обсуждение исходный текст |
Ответ на | very slow when writing query to file (boris pezzatti <boris.pezzatti@wsl.ch>) |
Ответы |
Re: very slow when writing query to file
(Fernando Hevia <fhevia@gmail.com>)
|
Список | pgadmin-support |
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:
Swiss Federal Research Institute WSL
Swiss Federal Research Institute WSL
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:
Boris PezzattiI propose you output to a file located on the same server as the DB and then copy that file to your PCIMO 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 fileNo, 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 fileDoes 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 --
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 PezzattiSwiss 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 |
В списке pgadmin-support по дате отправления:
Предыдущее
От: Jan-Peter.Seifert@gmx.deДата:
Сообщение: Re: 1.12.1 - cannot dump from older server versions