Re: Out of memory error

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Out of memory error
Дата
Msg-id 4207A63F.6050907@commandprompt.com
обсуждение исходный текст
Ответ на Out of memory error  (Clodoaldo Pinto <clodoaldo.pinto@gmail.com>)
Ответы Re: Out of memory error  (Clodoaldo Pinto <clodoaldo.pinto@gmail.com>)
Список pgsql-general
> Feb  7 16:30:25 s1 kernel: Free swap:            0kB
> Feb  7 16:30:25 s1 kernel: 258032 pages of RAM
> Feb  7 16:30:25 s1 kernel: 28656 pages of HIGHMEM
> Feb  7 16:30:25 s1 kernel: 3138 reserved pages
> Feb  7 16:30:26 s1 kernel: 14914 pages shared
> Feb  7 16:30:26 s1 kernel: 551 pages swap cached
> Feb  7 16:30:26 s1 kernel: Out of Memory: Killed process 30679 (psql).
>
> Any advice on how to avoid it?

Use a cursor.

> Regards, Clodoaldo Pinto
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


--
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage,  and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com


Вложения

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

Предыдущее
От: Daniel Schuchardt
Дата:
Сообщение: PG 8.0.1 Does not use Index with IS NOT NULL
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: tsearch2 Trigger