Re: Out of memory error

> 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