X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1B417D1B383 for ; Thu, 22 Jul 2004 20:57:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14048-08 for ; Thu, 22 Jul 2004 23:57:00 +0000 (GMT) Received: from cookie.varlena.com (adsl-64-142-36-103.sonic.net [64.142.36.103]) by svr1.postgresql.org (Postfix) with ESMTP id 04600D1B16A for ; Thu, 22 Jul 2004 20:56:56 -0300 (ADT) Received: by cookie.varlena.com (Postfix on SuSE Linux 7.3 (i386), from userid 500) id DDF79394BA; Thu, 22 Jul 2004 16:57:13 -0700 (PDT) Date: Thu, 22 Jul 2004 16:57:13 -0700 From: elein To: David Fetter Cc: PG Hackers Subject: Re: Tutorial Message-ID: <20040722165713.A29889@cookie.varlena.com> Mail-Followup-To: David Fetter , PG Hackers References: <20040722222104.GU7751@fetter.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040722222104.GU7751@fetter.org> User-Agent: Mutt/1.3.22.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/1122 X-Sequence-Number: 56683 I think you are reviving the inheritance wars. Please do not cut out or dumb down anything that accurately documents our features. I think the section should remain, describing exactly how they work and making it clear exactly what parts inherited and what is not inherited. That is where the most confustion lies. I have a documented use case where the distributed nature of the indexes increases performance significantly in certain types of queries. But(!) I have not re-tested against a recent release so take that with a grain of salt. I also have the documentation of how table inheritance worked in Illustra and a bit on how it worked with Informix IUS. And can explain some of the thoughts behind it and the religious wars (offline!). However, inheritance should not take up a lot of energy that could be better spent adding sections to JOINs, etc. I like inhertitance, but believe that the usefulness of our implementation is limited and so the documentation should focus on other areas. elein On Thu, Jul 22, 2004 at 03:21:04PM -0700, David Fetter wrote: > Kind people, > > I am writing a document patch for the tutorials section, and would > like to change the section on inheritance to reflect the fact that it > is not currently being developed, and has known serious bugs in > implementation. > > I'm thinking that I should either change that section to a warning > about why this is an unsupported feature or remove it entirely, and > add some other tutorials, details TBD. Some candidates for these > would include: > > * JOINs > * set-returning functions > * ARRAYs > * version-dependant (I presume) hacks like ORDER BY ... LIMIT 1 vs MIN/MAX > * the perennial Stuff Dave Has Not Though Of. > > What do you all think? > > Cheers, > D > -- > David Fetter david@fetter.org http://fetter.org/ > phone: +1 510 893 6100 mobile: +1 415 235 3778 > > Remember to vote! > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html