Re: "out of memory" error

On Wed, Aug 22, 2007 at 07:07:20PM +0200, Christian Schröder wrote:
> These are the current settings from the server configuration:
>    shared_buffers = 3GB

this is *way* to much. i would suggest lowering it to 1gig *at most*.

>    max memory size         (kbytes, -m) 3441565

this looks like too close to shared_buffers. again - lower it.

> The machine is a linux box with 4 GB memory running PostgreSQL 8.2.4.

is it by any chance i386 architecture?

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)