Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit3282b63

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 parent16843ba commit3282b63

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 1712:03:45 EST 2005
5+
Last updated:Sat Dec 1713: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
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Sat Dec 1712:03:45 EST 2005
11+
Last updated: Sat Dec 1713:06:57 EST 2005
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="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><aname="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)

[8]ページ先頭

©2009-2025 Movatter.jp