From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kyle Bateman <kyle@actarg.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: PG 8.2beta reordering working for this case?
Date: Sun, 08 Oct 2006 13:49:31 -0400
Message-ID: <25779.1160329771@sss.pgh.pa.us> (raw)
In-Reply-To: <45284DBC.3060901@actarg.com>
References: <44DF6582.4000806@actarg.com>
<82mza77rch.fsf@mid.bfk.de>
<44E11E1A.8020507@actarg.com>
<27367.1155606817@sss.pgh.pa.us>
<44E349BA.4070205@actarg.com>
<26676.1155747492@sss.pgh.pa.us>
<44E3840E.4080502@actarg.com>
<45284DBC.3060901@actarg.com>
Kyle Bateman <kyle@actarg.com> writes:
> Is there a way to make the optimizer do this?
Sorry, that's not happening for 8.2. Consider using a union all (not
union) across the subledg_N tables directly and then joining to that.
That boils down to being a partitioning case and I think probably will
be covered by the 8.2 improvements. There isn't any understanding of
how to commute joins and unions though ... (offhand I'm not even sure
of the conditions under which such a thing would be safe).
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, kyle@actarg.com
Subject: Re: PG 8.2beta reordering working for this case?
In-Reply-To: <25779.1160329771@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox