From: Greg Stark <gsstark@mit.edu>
To: ken <southerland@samsixedd.com>
Cc: Greg Stark <gsstark@mit.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: inheritance performance
Date: 21 Jan 2005 13:16:09 -0500
Message-ID: <87oefi8x7a.fsf@stark.xeocode.com> (raw)
In-Reply-To: <1106330319.6622.276.camel@pesky.s6portland>
References: <1106295545.6622.266.camel@pesky.s6portland>
<87hdlaahez.fsf@stark.xeocode.com>
<1106330319.6622.276.camel@pesky.s6portland>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsstark@mit.edu, southerland@samsixedd.com
Subject: Re: inheritance performance
In-Reply-To: <87oefi8x7a.fsf@stark.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox