Re: Our trial to TPC-DS but optimizer made unreasonable plan - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: Our trial to TPC-DS but optimizer made unreasonable plan
Date
Msg-id CAJjS0u0LP2+XkMe-3H4Xj70rihUA6SbcUmcuJcw_aYKc1r_Bxw@mail.gmail.com
Whole thread Raw
In response to Re: Our trial to TPC-DS but optimizer made unreasonable plan  (Qingqing Zhou <zhouqq.postgres@gmail.com>)
List pgsql-hackers
On Thu, Aug 27, 2015 at 1:01 PM, Qingqing Zhou
<zhouqq.postgres@gmail.com> wrote:
> On Wed, Aug 26, 2015 at 5:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> After looking at the code a bit, IMO the most reasonable thing to do is to
>> include this transformation in inline_set_returning_functions(), perhaps
>> renaming it to something like inline_srfs_and_ctes().
>>
>
> This is essentially the same as my current implementation (revised
> patch attached):
>

I tried the method as Tom suggested (attached in previous email) but
still got the same issue - anybody see what I did wrong here? :-(

Thanks,
Qingqing



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Missing latex-longtable value
Next
From: Andres Freund
Date:
Subject: Re: Our trial to TPC-DS but optimizer made unreasonable plan