Re: inheritance performance

From: Ioannis Theoharis <theohari(at)ics(dot)forth(dot)gr>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: ken <southerland(at)samsixedd(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: inheritance performance
Date: 2005-01-22 01:09:28
Message-ID: Pine.GSO.4.58.0501220307100.6097@ourania.ics.forth.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 21 Jan 2005, Greg Stark wrote:

> There's also a slight performance hit because there's an optimization that the
> planner does normally for simple queries that isn't currently done for either
> UNION ALL or inherited tables. I think it's planned to fix that soon.

Can you explain me in more details what kind of optimization is missing in
that case?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tatsuo Ishii 2005-01-22 03:01:28 Re: PostgreSQL clustering VS MySQL clustering
Previous Message Josh Berkus 2005-01-22 00:34:39 Re: PostgreSQL clustering VS MySQL clustering