Re: out of memory - no sort

Поиск
Список
Период
Сортировка
От Don
Тема Re: out of memory - no sort
Дата
Msg-id 4E5E66C3.4080003@noaa.gov
обсуждение исходный текст
Ответ на Re: out of memory - no sort  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: out of memory - no sort  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: out of memory - no sort
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: out of memory - no sort