| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Piotr Stefaniak <postgres(at)piotr-stefaniak(dot)me> |
| Cc: | Andreas Seltenreich <seltenreich(at)gmx(dot)de>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [sqlsmith] Failed assertion in joinrels.c |
| Date: | 2015-08-05 18:43:58 |
| Message-ID: | 9422.1438800238@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Piotr Stefaniak <postgres(at)piotr-stefaniak(dot)me> writes:
> On 08/05/2015 02:24 AM, Tom Lane wrote:
>> Piotr Stefaniak <postgres(at)piotr-stefaniak(dot)me> writes:
>>> Set join_collapse_limit = 32 and you should see the error.
>> Ah ... now I get that error on the smaller query, but the larger one
>> (that you put in an attachment) still doesn't show any problem.
>> Do you have any other nondefault settings?
> Sorry, that needs from_collapse_limit = 32 as well.
Yeah, I assumed as much, but it still doesn't happen for me. Possibly
something platform-dependent in statistics, or something like that.
Anyway, I fixed the problem exposed by the smaller query; would you
check that the larger one is okay for you now?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Farrer | 2015-08-05 18:44:48 | Removing unreferenced files |
| Previous Message | Andres Freund | 2015-08-05 18:36:17 | Re: LWLock deadlock and gdb advice |