X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 760B5D1B1AE for ; Wed, 7 Jul 2004 12:24:03 -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 55748-04 for ; Wed, 7 Jul 2004 15:23:55 +0000 (GMT) Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.50]) by svr1.postgresql.org (Postfix) with ESMTP id BDFF2D1B23F for ; Wed, 7 Jul 2004 12:23:54 -0300 (ADT) Received: from mailhost.ics.forth.gr (nemesis.ics.forth.gr [139.91.157.50]) by mailhost.ics.forth.gr (8.12.10/ICS-FORTH/V10-Server-1.0) with SMTP id i67FNeF3017841 for ; Wed, 7 Jul 2004 18:23:53 +0300 (EEST) Received: (from ASSP-nospam [127.0.0.1]) by mailhost.ics.forth.gr (SAVSMTP 3.1.0.29) with SMTP id M2004070718235315651 for ; Wed, 07 Jul 2004 18:23:53 +0300 Received: from 139.91.184.28 ([139.91.184.28] helo=ourania.ics.forth.gr) by ASSP-nospam ; 7 Jul 04 15:23:53 -0000 Received: from ourania.ics.forth.gr (localhost [127.0.0.1]) by ourania.ics.forth.gr (8.12.10+Sun/8.12.2) with ESMTP id i67FNrXQ009722 for ; Wed, 7 Jul 2004 18:23:53 +0300 (EEST) Received: from localhost (theohari@localhost) by ourania.ics.forth.gr (8.12.10+Sun/8.12.2/Submit) with ESMTP id i67FNqBV009718 for ; Wed, 7 Jul 2004 18:23:52 +0300 (EEST) Date: Wed, 7 Jul 2004 18:23:52 +0300 (EEST) From: Ioannis Theoharis To: pgsql-docs@postgresql.org Subject: Implementation of Inheritance in Postgres Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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/11 X-Sequence-Number: 2419 I would like to ask you where i can find information about the implementation of the inheritance relationship in Postgres. There are several ways to store and to retrieve instances contained in an hierarchie. Which clustering and buffer replacement policy implements Postgres? There is a system table called pg_inherits, but how is it used during hierarchies traversing?