Re: out of memory - no sort - Mailing list pgsql-general

From Don
Subject Re: out of memory - no sort
Date
Msg-id 4E5E66C3.4080003@noaa.gov
Whole thread Raw
In response to Re: out of memory - no sort  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: out of memory - no sort  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general
<meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">


    The server is 64 bit and client is 32 bit...  I tried the select
      * from table on the server and the query worked...
    but I am puzzled why it does not work on the 32bit machine.  I had
    always thought that a 32bit machine could access up to 4GB.
    So what is the limiting factor ?



    On 8/31/2011 8:57 AM, Scott Ribe wrote:
    <blockquote
      cite="mid:AD443F0B-D050-4E79-B277-AF9A5DB9AF06@elevated-dev.com"
      type="cite">
      On Aug 31, 2011, at 9:51 AM, Don wrote:



        Both machines are 64bit.



Are all your server & client builds 64-bit?

32M rows, unless the rows are <50 bytes each, you'll never be able to manipulate that selection in memory with a
32-bitapp. 

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: out of memory - no sort
Next
From: Scott Ribe
Date:
Subject: Re: out of memory - no sort