Enhance 5.8. Inheritance
Hi,
Just a quick comment about
http://www.postgresql.org/docs/9.4/static/ddl-inherit.html
I think in this page should mention partitioning (5.9) in the very first
paragraph. Or some way hint the reader that might be the actual thing
they're after.
Years ago I was learning about splitting tables into smaller pieces and I
found this inheritance manual page but it didn't make any sense because it
talks about cities and capitals and there aren't that many of them. So why
I would need this? Then I asked about inheritance usage in a forum and I
got statistics and logs as examples. This changed my mind to thinking about
tables splitted into years and months and multi-million lines of data
instead of some hundreds (that cities and states example). Only then I
found what I was actually looking for, partitioning.
Partitioning manual page is very good because measurements is used as
example. This gets the reader/developer into the "lots of data" mindset
which starts questioning performance.
--
Pekka Järvinen
On 11/19/14 5:30 PM, Pekka Järvinen wrote:
Just a quick comment about
http://www.postgresql.org/docs/9.4/static/ddl-inherit.html
I think in this page should mention partitioning (5.9) in the very first
paragraph. Or some way hint the reader that might be the actual thing
they're after.
I think the current setup is fine. Inheritance is a legitimate DDL
feature of its own. Someone who is specifically looking for
partitioning can find section 5.9 via the table of contents or the index.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs