Postgres Pro
Downloads
Home   >   mailing lists

Re: effective SELECT from child tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: effective SELECT from child tables
Date
Msg-id 9475.1127846292@sss.pgh.pa.us
Whole thread Raw
In response to effective SELECT from child tables  ("Ilia Kantor" <ilia@obnovlenie.ru>)
Responses Re: effective SELECT from child tables
List pgsql-hackers
Tree view 
"Ilia Kantor" <ilia@obnovlenie.ru> writes:
> 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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: effective SELECT from child tables
Next
From: Jan Wieck
Date:
Subject: Re: Vacuum questions...