From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Maurice Gittens <mgittens@gits.nl>
Cc: hackers@postgresql.org
Subject: Re: [HACKERS] On improving OO support in posgresql and relaxing oid bottleneck at the same time
Date: Sun, 05 Apr 1998 15:44:07 +0000
Message-ID: <3527A6C7.F075980C@alumni.caltech.edu> (raw)
References: <009e01bd6097$31a58060$fcf3b2c2@caleb..gits.nl>
> 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 stored in one file.
I hate to sound like a "small thinker" here, but I'd be concerned about
some issues:
1) true OO semantics are difficult/impossible to accomplish with SQL.
This is one reason why Postgres is probably in the OR realm rather than
true OO.
2) Supporting inheritance using one-file storage probably leads to
larger overhead in _all_ file accesses, not just ones containing
inherited tables. Tuples would now contain a variable number of fields,
with variable definitions, with ... Ack! :)
3) Indices are fundamentally present to speed up access, though we use
them for other purposes too (such as enforcing uniqueness). Perhaps the
topic of inheritance, uniqueness, and referential integrity (foreign
keys, etc) should be solved (or at least discussed) independent of
indices, though indices or index-like structures may be involved in the
solution.
4) imho, the roughest areas of existing (or missing) capability in
Postgres involve array types and types which require additional support
information (such as exact numerics). Focusing on fixing/improving these
areas may lead to cleaning up semantics, mechanisms, and capabilities in
the backend, and make other (more derived?) features such as constraint
inheritance and enforcement easier to implement. Well, it will help
something anyway, even if not constraints :)
- Tom
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: lockhart@alumni.caltech.edu, 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: <3527A6C7.F075980C@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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