On 4/11/06, MG <[EMAIL PROTECTED]> wrote:
> In on extreme case the application makes 100 000 INSERTs, in the other
> extreme case 100 000 UPDATES. Normally the UPDATES are more that INSERTs.
> Here I notice that the first case (100 000 INSERTs) takes about 30 minues,
> but the 100 000 UPDATES a
The possible solution would be, that you first insert the file into a temporary table via COPY.
have a full outer join on you current table with the temporary one on the basis of the primary column(s) assuming id.
only update the column where the outer table join is not null and insert all the rows
