diff options
author | Bruce Momjian <bruce@momjian.us> | 2007-05-05 15:40:01 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2007-05-05 15:40:01 +0000 |
commit | 4835df303dae1b21c3c334202bea6d698cd38b75 (patch) | |
tree | 04ed9516bad67224f6dcba36d1c76c33273b7258 /src/backend/executor/nodeFunctionscan.c | |
parent | dc9d3947e63391a09e27cd480f9221c149e1f30d (diff) | |
download | postgresql-4835df303dae1b21c3c334202bea6d698cd38b75.tar.gz postgresql-4835df303dae1b21c3c334202bea6d698cd38b75.zip |
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
Diffstat (limited to 'src/backend/executor/nodeFunctionscan.c')
0 files changed, 0 insertions, 0 deletions