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 _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
