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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
