Re: Problem on Linux - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problem on Linux
Date
Msg-id 104.1053625616@sss.pgh.pa.us
Whole thread Raw
In response to Problem on Linux  ("Molenda, Mark P" <mark.molenda@eds.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: timestamp data type?
Next
From: Steve Crawford
Date:
Subject: Re: Unaccounted for disk use