Re: effective SELECT from child tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: effective SELECT from child tables
Date: 2005-09-27 18:38:12
Message-ID: 9475.1127846292@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

"Ilia Kantor" <ilia(at)obnovlenie(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2005-09-27 18:47:46 Re: Vacuum questions...
Previous Message Josh Berkus 2005-09-27 18:34:33 Re: effective SELECT from child tables