Re: inheritance performance - Mailing list pgsql-performance

From Greg Stark
Subject Re: inheritance performance
Date
Msg-id 87oefi8x7a.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: inheritance performance  (ken <southerland@samsixedd.com>)
List pgsql-performance
ken <southerland@samsixedd.com> writes:

> On Fri, 2005-01-21 at 08:14, Greg Stark wrote:
> > ken <southerland@samsixedd.com> writes:
> >
> > > >From my understanding, all the data for these columns in all the child
> > > tables will be stored in this one parent table
> >
> > No, all the data is stored in the child table.
>
> So if you perform a "select * from parent" then does postgres internally
> create a union between all the child tables and return you the results
> of that?

Essentially, yes.

--
greg

pgsql-performance by date:

Previous
From: ken
Date:
Subject: Re: inheritance performance
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: inheritance performance