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

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Done: < Last updated: Sat May 5 10:47:39 EDT 2007 > Last
Date: 2007-05-05 15:40:01
Message-ID: 20070505154001.5FB469FB56F@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2007-05-05 17:05:49 pgsql: Check return code from strxfrm on Windows since it has a
Previous Message Bruce Momjian 2007-05-05 14:47:45 pgsql: Move item: < * Invalidate prepared queries, like INSERT, when