Optimizing SQL: bind variables, prepared stms, histograms

From: <lnd(at)hnit(dot)is>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Optimizing SQL: bind variables, prepared stms, histograms
Date: 2004-01-23 09:45:40
Message-ID: 0A5B2E3C3A64CA4AB14F76DBCA76DDA44EF9AD@seifur.hnit.is
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A few question regarding PostgreSQL handling of queries:

- Is each query submitted parsed and planned even if it is identical to a
query submitted before?
For example, 10 queries "select * from animals where id=:b1" with possibly
different bind variable :b1 values will be fully processed (parsed and
planned) 10 times?

- does it make difference for postgreSQL performance if bind variables are
used or not?
Does it make difference in performance if the same prepared statement is used
just with different values of bind variables?

- Does postgreSQL optimizer account for statistics like histograms when bind
variables are used (i.e. try to built a new plan given a concrete value of
bind variable)?

Thank you in advance,
Laimis

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2004-01-23 15:38:54 sequence in schema -- broken default
Previous Message Mike Mascari 2004-01-23 09:42:29 Re: Touch row ?