What executes faster? - Mailing list pgsql-hackers

From Haller Christoph
Subject What executes faster?
Date
Msg-id 200110010924.LAA27222@rodos
Whole thread Raw
Responses Re: What executes faster?
List pgsql-hackers
[HACKERS] What executes faster? 
Now that I've found the solution for my duplicate key problem, 
I'm wondering what executes faster when I have to check for 
duplicates. 1. try to update    if no row affected -> do the insert    else done 2. do a select    if row not found ->
dothe insert    else do the update 
 
Another idea I'm thinking about: 
I'm doing the check for duplicate key by myself now. 
Aren't insert commands running faster, if I replace 
an unique index by a not-unique index. 

Regards, Christoph 


pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: Spinlock performance improvement proposal
Next
From: "Reinoud van Leeuwen"
Date:
Subject: Re: What executes faster?