Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Date
Msg-id 14648.1256928755@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-bugs
Stefan Kaltenbrunner <stefan@kaltenbrunner.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

pgsql-bugs by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Next
From: Tom Lane
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault