Search Postgresql Archives

Re: out of memory - no sort

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:
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-bit app.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux