part_doc_pg10_v5.patch :
+ query planning and execution. The query planner is generally able to
+ handle partition hierarchies up a few hundred partition. Planning times
"up TO a few hundred partition*S*" ?
part_doc_master_v5.patch:
+ Choosing the target number of partitions into which the table should be
+ divided by is also a critical decision to make.
"into which ... should be divided by" seems like a copy-editing
mistake. Did you mean to remove either the "into which" or the "by"?
I think "the target number of partitions THAT the table should be
divided into" is simple and sensible; I'm not sure I trust the version
with "into which" instead of "that", and the role of "by" is not clear
to me ("divide by" implies a divisor, but here we're talking about the
resulting chunks and not the divisor).
In this phrase (all versions):
+ That's because each partition requires its own metadata that must be
+ loaded into the local memory of each session that touches it.
I would replace "requires its own metadata that must be loaded" with
"requires its metadata to be loaded".
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services