On Wed, Jan 6, 2010 at 3:53 PM, Zintrigue <zintri...@gmail.com> wrote: > I'm wondering if there's any performance penalty here, analogous to the > penalty of JOINs in a regular RDBMS (versus an ORDBMS). > If anyone can offer in any insight as too how inheritance is actually > executed (compared to JOINs especially), I'd be most grateful.
PostgreSQL inheritance is just a sugar coated form of horizontal table partitioning. So it suffers from all of the problems associated with selection on UNION ALL queries. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
