Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group