Tom believes there may be a memory leak, which would be causing the
(strangely enough) memory problem. Didn't think about reducing the import
size. What I might try in that case would be to re-connect to the db
periodically, rather than splitting the file. The problem becomes
unmanageable after around 15000 entries, so splitting 2.5M lines wouldn't be
pleasant (167 files).
Thanks,
Rob
Robert Creager
Senior Software Engineer
Client Server Library
303.673.2365 V
303.661.5379 F
888.912.4458 P
StorageTek
INFORMATION made POWERFUL
> -----Original Message-----
> From: Gordon A. Runkle [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 09, 2001 7:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] COPY problem
>
> I can't answer the backend question, but how about running
> 'split' on the big file, then COPYing these smaller files?
>
> Gordon.
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
