What executes faster?

From: Haller Christoph <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: What executes faster?
Date: 2001-10-01 11:24:11
Message-ID: 200110010924.LAA27222@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 -> 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

Browse pgsql-hackers by date

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