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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
  • 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 11:34:03 -0400
  • Message-id: <8701.1256916843@sss.pgh.pa.us> <text/plain>
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
Home | Main Index | Thread Index

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