Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 059CD632DA0 for ; Wed, 6 Jan 2010 20:00:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55082-01 for ; Thu, 7 Jan 2010 00:00:16 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f192.google.com (mail-yx0-f192.google.com [209.85.210.192]) by mail.postgresql.org (Postfix) with ESMTP id E61156327E5 for ; Wed, 6 Jan 2010 20:00:12 -0400 (AST) Received: by yxe30 with SMTP id 30so20010157yxe.29 for ; Wed, 06 Jan 2010 16:00:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=OrkRhKryToR/YL1++KNEF6tamLbk6+g3C0ZAmJZ8RJU=; b=d31hCwljGRGp4aqp5kjDZmnJPz/Px8YnhU5Oo3pNM5MFypLLQXIq3yxei+mV5Hpm7m qCjKiZVtOiuhHophlKnt9ZqrQAZOLS2ZmD/RbHQtJd4dX+g+MdRd0x/GKMQGH10HbNVR nq1jK5OW45xjktgUfvPAeTN0gDNmzTjhRWgAg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=hwf0oUxqt/9sA4kF4nRwxV2oChj3r71+uBFMerY+s33x7R+XBoQflhXE8HmMdUmQiK WE3Om8R1+kO/ot5UvLnlsKHdnZT4+5YX/XNu/8vp5KLTr4/w+TlViN7HdTs5cQVAO3Vf 9Zi5bwgdUA7Kywst0ehsmxXw6cJUGlv8NR/ko= MIME-Version: 1.0 Received: by 10.100.200.9 with SMTP id x9mr12747207anf.76.1262822411132; Wed, 06 Jan 2010 16:00:11 -0800 (PST) In-Reply-To: <22f7878e1001061553j69b3b461hadd4633c58c5304f@mail.gmail.com> References: <22f7878e1001061553j69b3b461hadd4633c58c5304f@mail.gmail.com> Date: Wed, 6 Jan 2010 16:00:11 -0800 Message-ID: <396486431001061600h69360a21xb7cf05677308ca26@mail.gmail.com> Subject: Re: noob inheritance question From: Richard Broersma To: Zintrigue Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.078 tagged_above=-10 required=5 tests=BAYES_05=-1.11, FH_DATE_PAST_20XX=3.188 X-Spam-Level: ** X-Archive-Number: 201001/66 X-Sequence-Number: 36946 On Wed, Jan 6, 2010 at 3:53 PM, Zintrigue 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