Re: effective SELECT from child tables

From: "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: effective SELECT from child tables
Date: 2005-09-28 08:13:43
Message-ID: auto-000571638207@umail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2005-09-28 09:05:48 Re: Making pgxs builds work with a relocated installation
Previous Message Ilia Kantor 2005-09-28 08:12:53 Re: effective SELECT from child tables