| From: | Don <Donald(dot)Laurine(at)noaa(dot)gov> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: out of memory - no sort |
| Date: | 2011-08-31 16:52:19 |
| Message-ID: | 4E5E66C3.4080003@noaa.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
The server is 64 bit and client is 32 bit... I tried the <i>select
* from table</i> on the server and the query worked...<br>
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.<br>
So what is the limiting factor ?<br>
<br>
<br>
<br>
On 8/31/2011 8:57 AM, Scott Ribe wrote:
<blockquote
cite="mid:AD443F0B-D050-4E79-B277-AF9A5DB9AF06(at)elevated-dev(dot)com"
type="cite">
<pre wrap="">On Aug 31, 2011, at 9:51 AM, Don wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Both machines are 64bit.
</pre>
</blockquote>
<pre wrap="">
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.
</pre>
</blockquote>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2011-08-31 17:03:22 | Re: [GENERAL] pg_upgrade problem |
| Previous Message | Robert Haas | 2011-08-31 16:32:04 | Re: [GENERAL] pg_upgrade problem |