Re: inheritance performance - Mailing list pgsql-performance

From ken
Subject Re: inheritance performance
Date
Msg-id 1106330319.6622.276.camel@pesky.s6portland
Whole thread Raw
In response to Re: inheritance performance  (Greg Stark <gsstark@mit.edu>)
Responses Re: inheritance performance
Re: inheritance performance
List pgsql-performance
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?

ken



pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering
Next
From: Greg Stark
Date:
Subject: Re: inheritance performance