[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
1. try to update
if no row affected -> do the insert
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.
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?|