Re: BUG #1015: Got a signal 11 while trying to create a temp table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: A(dot)j(dot)langereis(at)chello(dot)nl
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1015: Got a signal 11 while trying to create a temp table
Date: 2003-12-19 03:41:56
Message-ID: 6104.1071805316@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> I tried to create a temp table and got my back-end restarting because of a signal 11.

Hmm. Can you get a debugger backtrace from the core dump?

> It seems to me, and please correct me if Im wrong, that there is a limit to the size that a join can handle.

No (and certainly not on a measly 3-million-row case). This could be a
data corruption problem, or something more subtle, but it's not that.

One way of testing the data-corruption theory is to see if you can
select all the data from the tables involved, without any join.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-12-19 03:54:29 Re: Urgent: Key constraints behaving weirdly
Previous Message Bruce Momjian 2003-12-19 02:28:40 Re: libpq3 + ssl memory leak