Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
effective SELECT from child tables
- From: "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
- To: <pgsql-hackers(at)postgresql(dot)org>
- Subject: effective SELECT from child tables
- Date: Tue, 27 Sep 2005 21:30:55 +0400
- Message-id: <auto-000571351417(at)umail(dot)ru>
|
Let table A be inherited by A1, A2, A3. How to select from A records where actual relations
are A1, A2 ? I found a way somewhere, it sounds like SELECT …
WHERE tableoid IN (a1.oid, a2.oid), but tableoid checks actually do seq scan. Like: SELECT * FROM sometable WHERE tableoid
=anything will do seq. scan on sometable.. So such way seems very ineffective: it seq scans and
filters records.. Maybe new constraint_exclusion staff could help to
exclude non-matching tables from inheritance query ? |
- Follow-Ups:
- Re: effective SELECT from child tables
- From: mark
- Re: effective SELECT from child tables
- From: Tom Lane
- Re: effective SELECT from child tables
- From: Josh Berkus
- Re: effective SELECT from child tables
- Prev by Date: Re: Making pgxs builds work with a relocated installation
- Next by Date: Re: [BUGS] BUG #1883: Renaming a schema leaves inconsistent
- Previous by thread: Install pg_regress script to support PGXS?
- Next by thread: Re: effective SELECT from child tables
- Indexes: