On Aug 31, 2011, at 10:52 AM, Don wrote:
> I had always thought that a 32bit machine could access up to 4GB.
> So what is the limiting factor ?
- Half of your memory space may be given over to memory-mapped I/O. Now you're
down to 2GB.
- Your process's executable, plus any libraries it uses, pl
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 fac
Hello
2011/8/31 Don :
> Pavel...
>
> Thanks for the reply...
>
> This still did not solve the issue. It seems odd that a simple select
> command in psql accessing 32MB of records should cause a problem. I have
> tables much larger than this and may want to access them the same way.
>
so there a
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_r...@elevated-dev.com
http://www.ele
Pavel...
Thanks for the reply...
This still did not solve the issue. It seems odd that a simple select
command in psql accessing 32MB of records should cause a problem. I
have tables much larger than this and may want to access them the same way.
I have 24 GB RAM on the sever and 32GB RAM
On 08/30/11 7:28 AM, Don wrote:
I am trying a simple access of a table and get an out of memory
error. How do I avoid this issue. It seems I have some configuration
set wrong.
Our system has 24GB of memory and is dedicated to the postgres database.
Back ground information
aquarec=> explain
Hello
if table is large, then client can raise this exception too
try to set FETCH_COUNT to 1000
http://www.postgresql.org/docs/8.4/interactive/app-psql.html
Regards
Pavel Stehule
2011/8/30 Don :
> I am trying a simple access of a table and get an out of memory error. How
> do I avoid this i
I am trying a simple
access of a table and get an out of
memory error. How do I avoid this issue. It seems I
have some configuration set wrong.
Our system has 24GB of memory and is dedicated to the postgres
database.
B
