| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
| Cc: | Greg Stark <gsstark(at)mit(dot)edu>, "Bernt M(dot) Johnsen" <Bernt(dot)Johnsen(at)sun(dot)com>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault |
| Date: | 2009-10-30 18:52:35 |
| Message-ID: | 14648.1256928755@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
> ok just assembled a new testcase from the querylog of the tool:
> http://www.kaltenbrunner.cc/files/rand_gen_crash.sql
Ah, that works (or should I say fails). Will take a look.
> However the error seems to go away after an ANALYZE... so I wonder if
> this is just another case of "if we missestimated the size of the
> hashtable we are doomed"
Well, we shouldn't dump core in any case.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-10-30 19:03:50 | Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault |
| Previous Message | Stefan Kaltenbrunner | 2009-10-30 18:47:49 | Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault |