Bind variables

From: Mladen Gogala <mgogala(at)vmsinfo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Bind variables
Date: 2010-07-02 18:42:48
Message-ID: 4C2E3328.2050507@vmsinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

What does optimizer do when it encounters a bind variable? Does it have
a method of "peeking", like some other databases or it has some
predefined values and percentages? Where are those defined, if they
exist, can someone point the particular part of the code? Are those
values configurable or are they hard-coded?

--

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-07-02 20:23:06 Re: Bind variables
Previous Message Bastiaan Olij 2010-07-02 09:50:01 Re: null vs empty string