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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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

  • From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
  • To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • Cc: "Bernt M. 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: Fri, 30 Oct 2009 16:43:22 +0100
  • Message-id: <4AEB099A.4080804@kaltenbrunner.cc> <text/plain>
Tom Lane wrote:

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?
this is 8.5a2 configured with ./configure --enable-cassert --enable-debug and just default settings(ie plain initdb with default settings). 
The OS is Debian Lenny/AMD64.


Stefan
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group