pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (8+ messages)  latest in thread

Message-ID: <87oefi8x7a.fsf@stark.xeocode.com>
Permalink:  ../87oefi8x7a.fsf@stark.xeocode.com/
Also on:    postgresql.org/message-id/87oefi8x7a.fsf@stark.xeocode.com

 · 

reply

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