Re: "Out of memory" errors.. - Mailing list pgsql-general

From Gregory Stark
Subject Re: "Out of memory" errors..
Date
Msg-id 87ir7jtzpf.fsf@oxford.xeocode.com
Whole thread Raw
In response to "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
Responses Re: "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
List pgsql-general
"Lim Berger" <straightfwd007@gmail.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

pgsql-general by date:

Previous
From: Alan J Batsford
Date:
Subject: Problem Designing Index
Next
From: jf
Date:
Subject: Re: UDFs