Search Postgresql Archives

Technical question on PREPARE statements and PLPGSQL cached plans

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

 



Hi;

I was wondering....  When is a PREPARE statement planned?  On first
execution?  At the time the PREPARE statement is called?

How does the planner decide what sorts of plans to use when the ideal
plan might change based on future runs?

Is this the same wrt PLPGSQL cached plans?  Or are they planned differently?

Best Wishes,
Chris Travers

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux