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

From Lim Berger
Subject Re: "Out of memory" errors..
Date
Msg-id 69d2538f0708130536v188afb4ew50bb704cdd986ddf@mail.gmail.com
Whole thread Raw
In response to Re: "Out of memory" errors..  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: "Out of memory" errors..  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
On 8/13/07, Gregory Stark <stark@enterprisedb.com> wrote:
> "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?
>



=# select version();
                                                version
----------------------------------------
 PostgreSQL 8.2.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.4.6 20060404 (Red Hat 3.4.6-3)
(1 row)


Thanks for any tips!

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Problem Designing Index
Next
From: Gregory Stark
Date:
Subject: Re: "Out of memory" errors..