Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Дата
Msg-id 14648.1256928755@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список 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 по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault