I wrote > That's what I did at first, but later I found better performance with > a TRIGGER on the permanent table that deletes the target of an UPDATE, > if any, before the UPDATE. [INSERT!] That's what PG does anyway, and now I can do > the entire UPDATE [INSERT] in one command. It's probably obvious, but what I should have said is that now I do the INSERT in one command; I have no need of an UPDATE. So I do no UPDATEs, only INSERTs. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
