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,
but tableoid checks actually do seq scan.
Like: SELECT * FROM sometable WHERE tableoid =anything will do seq. scan on
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 ?
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2005-09-27 17:51:03|
|Subject: Install pg_regress script to support PGXS?|
|Previous:||From: Jeffrey W. Baker||Date: 2005-09-27 17:26:28|
|Subject: Re: [PERFORM] A Better External Sort?|