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

Re: Optimizer oddness, possibly compounded in 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Optimizer oddness, possibly compounded in 8.1
Date: 2005-12-03 00:43:24
Message-ID: 10201.1133570604@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
>> (The larger point that joins of inheritance unions aren't well-planned
>> is true, but it's always been true...)

> It also seems to have a probkem with unions in views.

> Is there anything that can be done about this -- workarounds etc? Any
> plans to address it? We've got a couple of places where it's beginning
> to bite us due to growth of tables.

It's something that's on the ever-growing TODO list ... I dunno if
anyone has any near-term plans to work on it.  It'd definitely be
nice to teach the planner to do joins-over-unions well, and then
make inheritance just invoke that behavior instead of being a crocky
special case.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-12-03 00:47:15
Subject: Re: strange behavior (corruption?) of large production database
Previous:From: Joe ConwayDate: 2005-12-03 00:40:47
Subject: Re: strange behavior (corruption?) of large production

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