Re: Table inheritance implementation.

From: Vlad <marchenko(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Grzegorz Nowakowski" <krecik(at)e-wro(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Table inheritance implementation.
Date: 2007-01-04 16:39:03
Message-ID: cd70c6810701040839g7f305586q43ce3f3af5ae3c63@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Speaking of partitioning, I see there some improvements planed for
this feature in 8.3 - any info on what exactly users can expect? Any
possibility to improve it so we don't have to add insert trigger that
selects the right table for operation? Also, propagation of Alter
table on inherited tables is a sweat feature... :)

> 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

-- vlad

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arindam 2007-01-04 16:40:42 Re: Moving from 7.2.1 to 8.1.5 - looking for jdbc
Previous Message Tom Lane 2007-01-04 16:38:00 Re: Moving from 7.2.1 to 8.1.5 - looking for jdbc