"Molenda, Mark P" <mark.molenda@eds.com> writes:
> It seems that the SUN version (compiled from source) handled 13 million rows
> with ( I know this is not efficient ) Select * from tableName;
> The Linux box bumped me out of psql with the exact table structure but with
> only 4 million rows doing the same select *.
Sounds like you have a low ulimit -d setting on the Linux system.
regards, tom lane