| From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | Zintrigue <zintrigue(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: noob inheritance question |
| Date: | 2010-01-07 00:00:11 |
| Message-ID: | 396486431001061600h69360a21xb7cf05677308ca26@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jan 6, 2010 at 3:53 PM, Zintrigue <zintrigue(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Neill | 2010-01-07 00:13:45 | Re: noob inheritance question |
| Previous Message | Zintrigue | 2010-01-06 23:53:56 | noob inheritance question |