"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