Re: Out of memory error - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Out of memory error
Date
Msg-id 4207A63F.6050907@commandprompt.com
Whole thread Raw
In response to Out of memory error  (Clodoaldo Pinto <clodoaldo.pinto@gmail.com>)
Responses Re: Out of memory error
List 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


Attachment

pgsql-general by date:

Previous
From: Daniel Schuchardt
Date:
Subject: PG 8.0.1 Does not use Index with IS NOT NULL
Next
From: "Joshua D. Drake"
Date:
Subject: Re: tsearch2 Trigger