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

"aarjan langereis" <a.j.langereis@chello.nl> writes:
> I don't see that "ulimit -c 0".. nowhere in the script. Where do I have to
> put the "ulimit -c unlimited"?

I'd suggest adding it to the pg_ctl script.

> Select * from blocks; gave me the whole table (I didn't look at all records,
> but got a result in psql)
> select hostid, sum(amount) from blocks group by hostid; crashed (3,2M
> records used)

Hm.  What do you have sort_mem set to?  Does the EXPLAIN output show
different plans for these queries?

            regards, tom lane