Re: [PERFORM] improvement suggestions for performance design

2007-07-08 Thread Thomas Finneid
Kalle Hallivuori wrote: > COPY is plentitudes faster than INSERT: > http://www.postgresql.org/docs/8.1/interactive/sql-copy.html > > If you can't just push the data straight into the final table with > COPY, push it into a temporary table that you go through with the > database procedure. > > Sh

Re: [PERFORM] improvement suggestions for performance design

2007-07-08 Thread Kalle Hallivuori
Hi. 2007/7/8, Thomas Finneid <[EMAIL PROTECTED]>: Kalle Hallivuori wrote: > COPY is plentitudes faster than INSERT: > http://www.postgresql.org/docs/8.1/interactive/sql-copy.html > > If you can't just push the data straight into the final table with > COPY, push it into a temporary table