Re: Performance question - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance question
Date
Msg-id 25277.1057128688@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance question  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> I wasn't looking for safety so much as avoiding the insert if possible.
> ...
> The above would reduce (but not eliminate) the number attempts to insert
> duplicates and as such reduce the number of log error entries.

Fair enough, it would do that.  But you still need the surrounding retry
logic to cope when a collision does happen.

            regards, tom lane

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: Performance question
Next
From: Jean-Christian Imbeault
Date:
Subject: Re: Performance question