Re: Table inheritance implementation.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Grzegorz Nowakowski <krecik(at)e-wro(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table inheritance implementation.
Date: 2007-01-04 15:44:50
Message-ID: 17262.1167925490@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grzegorz Nowakowski <krecik(at)e-wro(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gunnar Wagenknecht 2007-01-04 15:57:57 Dependency conflicts on CentOS 4.4
Previous Message Tom Lane 2007-01-04 15:39:09 Re: Accessing a custom FileSystem (as in Mysql "Custom Engine")