Also, in my script I'm often running into problems of slow execution and space overflow. The reason I'm using COPY for heavy loads in that INSERT is incredibly slow (I'm not using indexes on my tables), UPDATEs are quite slow as well. I'm often getting "number of page slots needed exceeds max_fsm_pages" warnings on VACUUM. I've tried using dictionaries to speed up execution, but did not get much improvement. Any suggestions? Thanks.
-----Original Message----- From: [EMAIL PROTECTED] on behalf of Daryl Tester Sent: Wed 1/24/2007 7:56 PM To: PyGreSQL Development; [email protected] Subject: Re: [PyGreSQL] Incomplete COPY from file Marina Olhovsky wrote: > for i in my_ids: > outfile.write(`i[0]` + '\n') You should close, or at least flush the file before executing - > q2 = "COPY tbl_2(new_id) FROM '" + fname + "'" > db.query(q2) Regards, Daryl Tester _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
_______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
