Re: Out of memory error

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Clodoaldo Pinto <clodoaldo(dot)pinto(at)gmail(dot)com>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Out of memory error
Date: 2005-02-07 17:32:47
Message-ID: 4207A63F.6050907@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
jd.vcf text/x-vcard 640 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-02-07 17:34:38 Re: tsearch2 Trigger
Previous Message Daniel Schuchardt 2005-02-07 17:29:53 PG 8.0.1 Does not use Index with IS NOT NULL