John Hughes <[EMAIL PROTECTED]> writes:
> The problem is that inserting into temp_holding takes more than a SECOND PER
> ROW!
Offhand I'd bet on the repeated computations of max(core_leads.id) as
being the bulk of the problem. That's completely broken anyway since
if concurrent insertions are happening there's no guarantee you'll
get the same result each time. Consider using a sequence to
generate these IDs, and doing just one nextval() not several per
trigger call.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
