Thread: Optimizing SQL: bind variables, prepared stms, histograms

Optimizing SQL: bind variables, prepared stms, histograms

From
Date:

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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match