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
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
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
*To:* Guillaume Lelarge
same server as the DB
and then copy that file to your PC
IMO your problem is network related.
*From:* boris pezzatti
*To:* Francisco Leovey
*Cc:* "pgadmin-support@postgresql.org"
*Sent:* Sunday, October 30, 2011 6:28 PM
*Subject:* Re: [pgadmin-support] very slow when writing q
ched if there were some parts that took much longer than others,
but failed to find one.
--
*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
p
or maybe the retrieved data in RAM are somehow lazy bound ... ?
On 11/02/2011 08:58 AM, boris pezzatti wrote:
Thank you Fernando for reproducing this.
I suspect there must be some part of code in the
* for each row
* for each column
loops that result inefficient only on some machines or
a variable
and storing all at once (or let say in chunks of 100 Mb) could solve the
problem ...
On 11/02/2011 09:10 AM, boris pezzatti wrote:
or maybe the retrieved data in RAM are somehow lazy bound ... ?
On 11/02/2011 08:58 AM, boris pezzatti wrote:
Thank you Fernando for reproducing
g the workload involved in the
file writing process.
I searched if there were some parts that took much longer than others,
but failed to find one.
The effort is much appreciated. Thanks.
Regards,
Fernando.
--
*Boris Pezzatti
Swiss Federal Research Institute WSL
*
Research unit Communi
great,
thank you a lot Guillaume!
Cheers,
Boris
On 11/03/2011 12:20 PM, Guillaume Lelarge wrote:
On Thu, 2011-11-03 at 12:02 +0100, Guillaume Lelarge wrote:
On Thu, 2011-11-03 at 11:22 +0100, boris pezzatti wrote:
I tested after column types, and the colum that appears to create the
very
