[PyGreSQL] Incomplete COPY from file

[Christoph Zwerschke]

Marina Olhovsky wrote:
> 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.

What PostgreSQL version are you using? Did you tune PostgreSQL 
(http://www.varlena.com/GeneralBits/Tidbits/perf.html)?

Please also note that PyGreSQL offers the inserttable() method
as a wrapper around the COPY command which can be handy sometimes.

-- Christoph