Re: inheritance performance

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: inheritance performance
Дата
Msg-id 87oefi8x7a.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: inheritance performance  (ken <southerland@samsixedd.com>)
Список 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 по дате отправления:

Предыдущее
От: ken
Дата:
Сообщение: Re: inheritance performance
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: inheritance performance