File tree Expand file tree Collapse file tree 1 file changed +4
-4
lines changed Expand file tree Collapse file tree 1 file changed +4
-4
lines changed Original file line number Diff line number Diff line change @@ -4113,12 +4113,12 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01';
4113
4113
<para>
4114
4114
It is also important to consider the overhead of partitioning during
4115
4115
query planning and execution. The query planner is generally able to
4116
- handle partition hierarchies up a few hundred partitions fairly well,
4117
- provided that typical queries allow the query planner to prune all but a
4118
- small number of partitions. Planning times become longer and memory
4116
+ handle partition hierarchies with up to a few hundred partitions fairly
4117
+ well, provided that typical queries allow the query planner to prune all
4118
+ but a small number of partitions. Planning times become longer and memory
4119
4119
consumption becomes higher as more partitions are added. This is
4120
4120
particularly true for the <command>UPDATE</command> and
4121
- <command>DELETE</command> commands. Another reason to be concerned about
4121
+ <command>DELETE</command> commands. Another reason to be concerned about
4122
4122
having a large number of partitions is that the server's memory
4123
4123
consumption may grow significantly over a period of time, especially if
4124
4124
many sessions touch large numbers of partitions. That's because each
You can’t perform that action at this time.
0 commit comments