Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1015: Got a signal 11 while trying to create a temp table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1015: Got a signal 11 while trying to create a temp table
Date
Msg-id 6104.1071805316@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1015: Got a signal 11 while trying to create a temp table  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.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 I’m 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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: libpq3 + ssl memory leak
Next
From: Tom Lane
Date:
Subject: Re: Urgent: Key constraints behaving weirdly