Re: Prepared statements performance - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Prepared statements performance
Date
Msg-id CAF-3MvNjHJFq5RB=fKejCV91D6WVmD0FbPVWmo4c8=HHcgqQFw@mail.gmail.com
Whole thread Raw
In response to Re: Prepared statements performance  (Radosław Smogura <rsmogura@softperience.eu>)
Responses Re: Prepared statements performance
List pgsql-general
On 10 May 2012 15:05, Radosław Smogura <rsmogura@softperience.eu> wrote:
> May I ask what kind of planning may occur during insert?

Well, for example, if there's a unique constraint on the table then
the database will have to check that the newly inserted values don't
conflict with values that are already in the table. It needs to plan
an efficient strategy for that, which depends on the values being
inserted.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Prepared statements performance
Next
From: Tom Lane
Date:
Subject: Re: Prepared statements performance