Skip site navigation (1) Skip section navigation (2)

Re: very slow when writing query to file

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: boris pezzatti <boris(dot)pezzatti(at)wsl(dot)ch>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: very slow when writing query to file
Date: 2011-11-02 21:26:38
Message-ID: 1320269199.2145.30.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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


In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-11-02 21:28:22
Subject: Re: Bug, New Column... window, data type typing
Previous:From: Guillaume LelargeDate: 2011-11-02 21:25:32
Subject: Re: very slow when writing query to file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group