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

Commit69e5247

Browse files
committed
Doc: remove ancient comment.
There's a very old comment in rules.sgml added back to 2003. Itexpected to a feature coming back but it never happened. So now we cansafely remove the comment. Back-patched to all supported branches.Discussion:https://postgr.es/m/20190211.191004.219630835457494660.t-ishii%40sraoss.co.jp
1 parent301de4f commit69e5247

File tree

1 file changed

+0
-24
lines changed

1 file changed

+0
-24
lines changed

‎doc/src/sgml/rules.sgml

Lines changed: 0 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -2434,30 +2434,6 @@ Nestloop
24342434
in a command.
24352435
</para>
24362436

2437-
<!-- What's happening with this? If it doesn't come back, remove this section. -->
2438-
<!--
2439-
<para>
2440-
Another situation is cases on <command>UPDATE</command> where it depends on the
2441-
change of an attribute if an action should be performed or
2442-
not. The only way to
2443-
create a rule as in the shoelace_log example is to do it with
2444-
a rule qualification. That results in an extra query that is
2445-
performed always, even if the attribute of interest cannot
2446-
change at all because it does not appear in the target list
2447-
of the initial query. When this is enabled again, it will be
2448-
one more advantage of rules over triggers. Optimization of
2449-
a trigger must fail by definition in this case, because the
2450-
fact that its actions will only be done when a specific attribute
2451-
is updated is hidden in its functionality. The definition of
2452-
a trigger only allows to specify it on row level, so whenever a
2453-
row is touched, the trigger must be called to make its
2454-
decision. The rule system will know it by looking up the
2455-
target list and will suppress the additional query completely
2456-
if the attribute isn't touched. So the rule, qualified or not,
2457-
will only do its scans if there ever could be something to do.
2458-
</para>
2459-
-->
2460-
24612437
<para>
24622438
The summary is, rules will only be significantly slower than
24632439
triggers if their actions result in large and badly qualified

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp