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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-11-02 21:28:22 | Re: Bug, New Column... window, data type typing |
Previous Message | Guillaume Lelarge | 2011-11-02 21:25:32 | Re: very slow when writing query to file |