Skip site navigation (1) Skip section navigation (2)

Memory exhausted in AllocSetAlloc()

From: Thomas Heinis <postgres(at)mailzone(dot)ch>
To: pgsql-novice(at)postgresql(dot)org
Subject: Memory exhausted in AllocSetAlloc()
Date: 2001-03-14 12:46:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hey everybody,
whenever I do a 'select * from profil_ext2;' I get

FATAL 1:  Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

Now, I read the manual and I know that one can use ulimit to increase
the size of virtual memory. But with ulimit -a I get the following
core file size (blocks)  1000000
data seg size (kbytes)   unlimited
file size (blocks)       unlimited
max memory size (kbytes) unlimited
stack size (kbytes)      8192
cpu time (seconds)       unlimited
max user processes       2048
pipe size (512 bytes)    8
open files               1024
virtual memory (kbytes)  2105343

And I think 2105343 kbytes is fairly enough virtual memory.

Any suggestions on what I can do?



pgsql-novice by date

Next:From: pgsql-sqlDate: 2001-03-14 13:10:19
Previous:From: Anthony E . GreeneDate: 2001-03-14 07:05:24
Subject: Re: Re: Fwd: Silly question about numbering of rows?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group