Re: Performance question - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: Performance question
Date
Msg-id 3F028499.4000102@mega-bucks.co.jp
Whole thread Raw
In response to Performance question  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tom Lane wrote:
>
> Well, if that's how your application logic works then you're done.

Great! It's not _my_ application logic, someone else's. I'm trying to
find a way to make it more postgres friendly and generate less error
messages.

The application was first written for MySQL and the business _logic_
seems to have been to just throw inserts at the database and if they
failed it must be because the record was already there so no need to
worry about it.

Pretty loose logic but then again the app can be *very* write intensive
and the extra cycles needed to check whether something is  already in
the DB or not before inserting seems to be a real concern for the
application developers.

Jean-Christian Imbeault


pgsql-general by date:

Previous
From: Harry Yau
Date:
Subject: Which Schema I am working on??
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: Duplicate key insert question