Enhance 5.8. Inheritance

Started by Pekka Järvinenover 11 years ago2 messagesdocs
Jump to latest
#1Pekka Järvinen
pekka.jarvinen@gmail.com

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Pekka Järvinen (#1)
Re: Enhance 5.8. Inheritance

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