Postgres Pro
Downloads
Home   >   mailing lists

Re: inheritance performance - Mailing list pgsql-performance

From Ioannis Theoharis
Subject Re: inheritance performance
Date
Msg-id Pine.GSO.4.58.0501220307100.6097@ourania.ics.forth.gr
Whole thread Raw
In response to Re: inheritance performance  (Greg Stark <gsstark@mit.edu>)
Responses Re: inheritance performance  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
Tree view 

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?

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering
Next
From: Tatsuo Ishii
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering