Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: "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 15:34:03
Message-ID: 8701.1256916843@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
> uploaded a dump of the dataset here:
> http://www.kaltenbrunner.cc/files/rand_gen_data.sql
> and the query that causes the segfault:
> http://www.kaltenbrunner.cc/files/rand_gen_query.sql

[ scratches head... ]  Still no crash here, and I tried it on a couple
different types of hardware.  What configure parameters are you using,
and what non-default postgresql.conf settings?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Stefan KaltenbrunnerDate: 2009-10-30 15:43:22
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Previous:From: Tom LaneDate: 2009-10-30 13:59:38
Subject: Re: BUG #5147: DBA can not access view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group