Re: out of memory - no sort

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Don <Donald(dot)Laurine(at)noaa(dot)gov>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: out of memory - no sort
Date: 2011-08-31 15:57:48
Message-ID: AD443F0B-D050-4E79-B277-AF9A5DB9AF06@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Millington 2011-08-31 16:02:59 "invalid input syntax for type bytea"
Previous Message Don 2011-08-31 15:51:46 Re: out of memory - no sort