Re: "Out of memory" errors..

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Lim Berger" <straightfwd007(at)gmail(dot)com>
Cc: "Postgresql General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: "Out of memory" errors..
Date: 2007-08-13 11:56:44
Message-ID: 87ir7jtzpf.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lim Berger" <straightfwd007(at)gmail(dot)com> writes:

> Hi
>
> I am getting the following error while running queries such as "vacuum
> analyze TABLE", even on small tables with a piddly 35,000 rows!
>
> The error message:
> --
> ERROR: out of memory
> DETAIL: Failed on request of size 67108860.
> --
>
> My postgresql.conf is below. I am on a Dual Core server with 4GB or
> RAM, which runs MySQL as well (key_buffer for which is at around
> 800M).

What version of Postgres is this?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan J Batsford 2007-08-13 11:56:55 Problem Designing Index
Previous Message hubert depesz lubaczewski 2007-08-13 11:56:12 Re: UDFs