How does PG Inheritance work?

Поиск
Список
Период
Сортировка
От Announce
Тема How does PG Inheritance work?
Дата
Msg-id KBEKKNMFLELKGIADDEPEEEBKCDAA.truthhurts@insightbb.com
обсуждение исходный текст
Ответ на Re: How Can I use OO concepts?  (Chris Browne <cbbrowne@acm.org>)
Ответы Re: How does PG Inheritance work?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
How does Postgres internally handle inheritance under the following
scenario?
Using sample tables similar to a previous post:

 CREATE TABLE employee(id primary key, name varchar, salary numeric(6,2));
 CREATE TABLE programmer(language varchar, project varchar) INHERITS
(employee);
 CREATE TABLE representative (region varchar) INHERITS (employee);

Let's say for example's sake, there are 10 million rows of PROGRAMMER data
but only 100 rows of representative data.  Will a query (select, update,
insert, etc) on the REPRESENTATIVE table take a performance hit because of
this?

It seems like the child-table is really not concrete. It seems like it is
just a "pointer" to certain rows in the parent table which is then able to
discern which inherited "table-type" it is.

Thanks,

Aaron


В списке pgsql-novice по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: could not create unique index, table contains
Следующее
От: ig@freemail.gr (Çëßáò Ãêïõíôáñüðïõëïò)
Дата:
Сообщение: PostgreSQL 8.0.1-2 WinXP Services