agora inbox for pgsql-hackers@postgresql.org  

help / color / mirror / Atom feed

From: Maurice Gittens <mgittens@gits.nl>
To: hackers@postgreSQL.org
Subject: Re: [HACKERS] On improving OO support in posgresql and relaxing oid bottleneck at the same time
Date: Wed, 8 Apr 1998 16:59:21 +0200
Message-ID: <008b01bd62fe$e9de09e0$fcf3b2c2@caleb..gits.nl> (raw)

-----Original Message-----
From: Maurice Gittens <mgittens@gits.nl>
To: hackers@postgreSQL.org <hackers@postgreSQL.org>
Date: zondag 5 april 1998 21:47
Subject: [HACKERS] On improving OO support in posgresql and relaxing oid
bottleneck at the same time


>Hi,
>
>I'm currently under the impression that the following change in the
>postgresql system would benefict the overall performance and quality
>of the system.
>
>    Tuples for a class and all it's derived classes are stored in one file.
>
>Advantages:


 -- cut --
>
>
>Disadvantages
>- sequential heapscans for tables _with_ derived classes will be less
>efficient
>  in general,   because now some tuples may have to be skipped since they
>may
>  belong to the wrong class. This is easily solved using indices.
>
>- slight space overhead for tuple when not using inheritance.
>  The space is used to tag each tuple with the most derived class it
>  belongs to.
>

One extra disadvantage of this is that multiple inheritance is only
easily supported if bases classes being inherited from have a common
top most base class. In which all tuples are stored. Otherwise
we'll storagefile independant oid's will become necesary again.

So loosely speaking it still allows for multiple inheritance but only within
a common hierarchy.

With regards from Maurice.

view thread (6+ messages)  latest in thread

Message-ID: <008b01bd62fe$e9de09e0$fcf3b2c2@caleb..gits.nl>
Permalink:  ../008b01bd62fe$e9de09e0$fcf3b2c2@caleb..gits.nl/
Also on:    postgresql.org/message-id/008b01bd62fe$e9de09e0$fcf3b2c2@caleb..gits.nl

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: mgittens@gits.nl, hackers@postgreSQL.org
  Subject: Re: [HACKERS] On improving OO support in posgresql and relaxing oid bottleneck at the same time
  In-Reply-To: <008b01bd62fe$e9de09e0$fcf3b2c2@caleb..gits.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox