[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 -> do the 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 

Responses

• Re: What executes faster? at 2001-10-01 09:39:45 from Reinoud van Leeuwen

pgsql-hackers by date

Next:	From: Justin Clift	Date: 2001-10-01 11:40:41
	Subject: Re: Bulkloading using COPY - ignore duplicates?
Previous:	From: Lee Kindness	Date: 2001-10-01 11:04:41
	Subject: Bulkloading using COPY - ignore duplicates?