Skip to content

Commit 3282b63

Browse files
committed
Update:
< * Flush cached query plans when the dependent objects change or < when the cardinality of parameters changes dramatically > * Flush cached query plans when the dependent objects change, > when the cardinality of parameters changes dramatically, or > when new ANALYZE statistics are available
1 parent 16843ba commit 3282b63

File tree

2 files changed

+8
-6
lines changed

2 files changed

+8
-6
lines changed

doc/TODO

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated: Sat Dec 17 12:03:45 EST 2005
5+
Last updated: Sat Dec 17 13:06:57 EST 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -715,8 +715,9 @@ Referential Integrity
715715
Dependency Checking
716716
===================
717717

718-
* Flush cached query plans when the dependent objects change or
719-
when the cardinality of parameters changes dramatically
718+
* Flush cached query plans when the dependent objects change,
719+
when the cardinality of parameters changes dramatically, or
720+
when new ANALYZE statistics are available
720721
* Track dependencies in function bodies and recompile/invalidate
721722

722723
This is particularly important for references to temporary tables

doc/src/FAQ/TODO.html

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
99
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<a href="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Sat Dec 17 12:03:45 EST 2005
11+
Last updated: Sat Dec 17 13:06:57 EST 2005
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -652,8 +652,9 @@ <h1><a name="section_10">Referential Integrity</a></h1>
652652
<h1><a name="section_11">Dependency Checking</a></h1>
653653

654654
<ul>
655-
<li>Flush cached query plans when the dependent objects change or
656-
when the cardinality of parameters changes dramatically
655+
<li>Flush cached query plans when the dependent objects change,
656+
when the cardinality of parameters changes dramatically, or
657+
when new ANALYZE statistics are available
657658
</li><li>Track dependencies in function bodies and recompile/invalidate
658659
<p> This is particularly important for references to temporary tables
659660
in PL/PgSQL because PL/PgSQL caches query plans. The only workaround

0 commit comments

Comments
 (0)