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

Commit1bbcbfa

Browse files
committed
doc: Fix grammatical error in partitioning docs
Reported-by: Amit LangoteDiscussion:https://postgr.es/m/CA+HiwqGZFkKi0TkBGYpr2_5qrRAbHZoP47AP1BRLUOUkfQdy_A@mail.gmail.comBackpatch-through: 10
1 parentac8f2e1 commit1bbcbfa

File tree

1 file changed

+9
-9
lines changed

1 file changed

+9
-9
lines changed

‎doc/src/sgml/ddl.sgml

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -3982,15 +3982,15 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01';
39823982
<para>
39833983
It is also important to consider the overhead of partitioning during
39843984
query planning and execution. The query planner is generally able to
3985-
handle partition hierarchies up a few hundred partitions. Planning times
3986-
become longer and memory consumption becomes higher as more partitions are
3987-
added. This is particularly true for the <command>UPDATE</command> and
3988-
<command>DELETE</command> commands.Another reason to be concerned about
3989-
having a large number of partitions is that the server's memory
3990-
consumption may grow significantly over a period of time, especially if
3991-
many sessions touch large numbers of partitions. That's because each
3992-
partition requires its metadata to be loaded into the local memory of
3993-
each session that touches it.
3985+
handle partition hierarchieswithuptoa few hundred partitions.
3986+
Planning timesbecome longer and memory consumption becomes higher as more
3987+
partitions areadded. This is particularly true for the
3988+
<command>UPDATE</command> and <command>DELETE</command> commands. Another
3989+
reason to be concerned abouthaving a large number of partitions is that
3990+
the server's memoryconsumption may grow significantly over a period of
3991+
time, especially ifmany sessions touch large numbers of partitions.
3992+
That's because eachpartition requires its metadata to be loaded into the
3993+
local memory ofeach session that touches it.
39943994
</para>
39953995

39963996
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp