Re: effective SELECT from child tables

Поиск
Список
Период
Сортировка
От Ilia Kantor
Тема Re: effective SELECT from child tables
Дата
Msg-id auto-000571638207@umail.ru
обсуждение исходный текст
Ответ на Re: effective SELECT from child tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: effective SELECT from child tables  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
>> Let table A be inherited by A1, A2, A3.
>> How to select from A records where actual relations are A1, A2 ?

>Why not just select directly from the child tables?  I can't get excited
>about optimizing the case you propose.

Because "WHERE concrete_class IN (a,b,c)" is much more convenient and
flexible way of forming select then manually split request into many unions.


Also, this query runs on top of "abstract class", so inheritance really
assists me here.




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

Предыдущее
От: "Ilia Kantor"
Дата:
Сообщение: Re: effective SELECT from child tables
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Making pgxs builds work with a relocated installation