Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Tatsuo IshiiDate: 2005-01-22 03:01:28
Subject: Re: PostgreSQL clustering VS MySQL clustering
Previous:From: Josh BerkusDate: 2005-01-22 00:34:39
Subject: Re: PostgreSQL clustering VS MySQL clustering

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group