X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B240D1B1AE for ; Wed, 7 Jul 2004 12:13:52 -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 47834-08 for ; Wed, 7 Jul 2004 15:13:45 +0000 (GMT) Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.50]) by svr1.postgresql.org (Postfix) with ESMTP id E3CCFD1B196 for ; Wed, 7 Jul 2004 12:13:44 -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 i67FDgEx014864 for ; Wed, 7 Jul 2004 18:13:43 +0300 (EEST) Received: (from ASSP-nospam [127.0.0.1]) by mailhost.ics.forth.gr (SAVSMTP 3.1.0.29) with SMTP id M2004070718134214905 for ; Wed, 07 Jul 2004 18:13:42 +0300 Received: from 139.91.157.52 ([139.91.157.52] helo=calliope.ics.forth.gr) by ASSP-nospam ; 7 Jul 04 15:13:42 -0000 Received: from localhost (theohari@localhost) by calliope.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.2C-INTNULL) with ESMTP id SAA22125 for ; Wed, 7 Jul 2004 18:13:42 +0300 (EET DST) X-Authentication-Warning: calliope.ics.forth.gr: theohari owned process doing -bs Date: Wed, 7 Jul 2004 18:13:42 +0300 (EET DST) From: Ioannis Theoharis To: pgsql-performance@postgresql.org Subject: Implementatiion 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/19 X-Sequence-Number: 7410 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?