pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedEnhance 5.8. Inheritance
2+ messages / 2 participants
[nested] [flat]
* Enhance 5.8. Inheritance
@ 2014-11-19 22:30 Pekka Järvinen <pekka.jarvinen@gmail.com>
2014-12-12 04:12 ` Re: Enhance 5.8. Inheritance Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: Pekka Järvinen @ 2014-11-19 22:30 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Enhance 5.8. Inheritance
2014-11-19 22:30 Enhance 5.8. Inheritance Pekka Järvinen <pekka.jarvinen@gmail.com>
@ 2014-12-12 04:12 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2014-12-12 04:12 UTC (permalink / raw)
To: Pekka Järvinen <pekka.jarvinen@gmail.com>; pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-12-12 04:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-11-19 22:30 Enhance 5.8. Inheritance Pekka Järvinen <pekka.jarvinen@gmail.com>
2014-12-12 04:12 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox