• Bruce Momjian's avatar
    Done: · 4835df30
    Bruce Momjian authored
    < Last updated:		Sat May  5 10:47:39 EDT 2007
    > Last updated:		Sat May  5 11:39:57 EDT 2007
    < * Flush cached query plans when the dependent objects change,
    <   when the cardinality of parameters changes dramatically, or
    > * -Flush cached query plans when the dependent objects change or
    <
    <   A more complex solution would be to save multiple plans for different
    <   cardinality and use the appropriate plan based on the EXECUTE values.
    <
    < * Track dependencies in function bodies and recompile/invalidate
    <
    <   This is particularly important for references to temporary tables
    <   in PL/PgSQL because PL/PgSQL caches query plans.  The only workaround
    <   in PL/PgSQL is to use EXECUTE.  One complexity is that a function
    <   might itself drop and recreate dependent tables, causing it to
    <   invalidate its own query plan.
    <
    < * Invalidate prepared queries, like INSERT, when the table definition
    > * -Track dependencies in function bodies and recompile/invalidate
    > * -Invalidate prepared queries, like INSERT, when the table definition
    4835df30
TODO.html 78.8 KB