Memory exhausted in AllocSetAlloc()

Поиск
Список
Период
Сортировка
От Thomas Heinis
Тема Memory exhausted in AllocSetAlloc()
Дата
Msg-id 3AAF6819.28C30F77@mailzone.ch
обсуждение исходный текст
Ответы Re: Memory exhausted in AllocSetAlloc()  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
listing:
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?

Thomas


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Anthony E . Greene"
Дата:
Сообщение: Re: Re: Fwd: Silly question about numbering of rows?
Следующее
От: "Daniel A. Melo"
Дата:
Сообщение: compilation error