Search Postgresql Archives

Re: Prepare Statement VS Literal Values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This looks like early vs late binding problem, also seen in  other products.  When you prepare the sql, the optimizer
has no way of knowing the values which is going to be supplied in future.  So it is possible that at the time of preparing
PG settles on a plan and uses it for all values, regardless of its efficiency.
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux