On Wed, Jan 6, 2010 at 6:53 PM, Zintrigue <zintrigue@xxxxxxxxx> wrote: > I'm wondering if there's any performance penalty here There definitely is. Your design sounds pretty painful to me... adding a column referencing a side-table will be much nicer. > If anyone can offer in any insight as too how inheritance is actually > executed (compared to JOINs especially), I'd be most grateful. You can look at the query plans for your queries using EXPLAIN. Inheritance is really just UNION ALL under the covers - it's meant for partitioning, not the sort of thing you're trying to do here, so your query plans will probably not be too good with this design. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
