| From: | Qingqing Zhou <zhouqq(dot)postgres(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Kouhei Kaigai <kaigai(at)ak(dot)jp(dot)nec(dot)com>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Our trial to TPC-DS but optimizer made unreasonable plan |
| Date: | 2015-08-31 16:26:50 |
| Message-ID: | CAJjS0u0LP2+XkMe-3H4Xj70rihUA6SbcUmcuJcw_aYKc1r_Bxw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Aug 27, 2015 at 1:01 PM, Qingqing Zhou
<zhouqq(dot)postgres(at)gmail(dot)com> wrote:
> On Wed, Aug 26, 2015 at 5:28 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-08-31 16:36:32 | Re: Our trial to TPC-DS but optimizer made unreasonable plan |
| Previous Message | Bruce Momjian | 2015-08-31 16:24:49 | Re: Missing latex-longtable value |