Re: Prepared statements performance

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Radosław Smogura <rsmogura(at)softperience(dot)eu>
Cc: Daniel McGreal <daniel(dot)mcgreal(at)redbite(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Prepared statements performance
Date: 2012-05-10 13:48:04
Message-ID: CAF-3MvNjHJFq5RB=fKejCV91D6WVmD0FbPVWmo4c8=HHcgqQFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10 May 2012 15:05, Radosław Smogura <rsmogura(at)softperience(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Helmer 2012-05-10 14:42:21 Re: vacuum, vacuum full and problems releasing disk space
Previous Message Merlin Moncure 2012-05-10 13:36:04 Re: Prepared statements performance