Обсуждение: pgsql: Done: < Last updated: Sat May 5 10:47:39 EDT 2007 > Last

Поиск
Список
Период
Сортировка

pgsql: Done: < Last updated: Sat May 5 10:47:39 EDT 2007 > Last

От
momjian@postgresql.org (Bruce Momjian)
Дата:
Log Message:
-----------
Done:

< 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

Modified Files:
--------------
    pgsql/doc:
        TODO (r1.2179 -> r1.2180)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.2179&r2=1.2180)
    pgsql/doc/src/FAQ:
        TODO.html (r1.680 -> r1.681)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.680&r2=1.681)