On 4/6/04 3:55 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote: >> The kludge solution I implemented was to write out all the data I >> needed from table A to a file, then read that file and update table B. > > In theory at least, that should not be any faster than a WITH HOLD > cursor, since you're effectively replicating the same functionality > outside the database ... Except for the "out of memory" thing... Are you saying that once the first COMMIT completed, all COMMIT's after that would function at normal speed - only the first one has to save the result set? Wes ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
