Lonni Friedman <lfriedman(at)vasoftware(dot)com> writes:
>> Probably. "ulimit -c 0" is a common default these days. Try "ulimit -c
>> unlimited" before starting the postmaster (resp. psql).
> ok, is this even neccesary if the problem with the segfault is psql, and
> not the backend?
Yes, even more so, because I can't see any reason for psql to dump core
part way through showing a large result.
regards, tom lane