Re: "Out of memory" errors..

"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