Re: Table inheritance implementation. - Mailing list pgsql-general

From Tom Lane
Subject Re: Table inheritance implementation.
Date
Msg-id 17262.1167925490@sss.pgh.pa.us
Whole thread Raw
In response to Table inheritance implementation.  (Grzegorz Nowakowski <krecik@e-wro.net>)
Responses Re: Table inheritance implementation.
Re: Table inheritance implementation.
List pgsql-general
Grzegorz Nowakowski <krecik@e-wro.net> writes:
> But I have another question: why can't be
> inheritance implemented as implicit JOIN?

Interesting thought, but joins are expensive --- this would be quite a
lot slower than the current way, I fear, especially when you consider
more than one level of inheritance.  Also, switching over to this would
destroy the current usefulness of inheritance for partitioning.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Accessing a custom FileSystem (as in Mysql "Custom Engine")
Next
From: Tom Lane
Date:
Subject: Re: self-referential UPDATE problem on 7.4