Re: update 600000 rows - Mailing list pgsql-performance

From andrew@pillette.com
Subject Re: update 600000 rows
Date
Msg-id 200712162045.lBGKj2I03112@pillette.com
Whole thread Raw
In response to update 600000 rows  (okparanoid@free.fr)
List pgsql-performance
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. 

pgsql-performance by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: Large Objects and Toast
Next
From: James Mansion
Date:
Subject: Re: libgcc double-free, backend won't die