Re: "out of memory" error - Mailing list pgsql-general

From Mikko Partio
Subject Re: "out of memory" error
Date
Msg-id 2ca799770708240207v4c6fb3cax9b6d92b3176bf15a@mail.gmail.com
Whole thread Raw
In response to Re: "out of memory" error  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: "out of memory" error  (Martijn van Oosterhout <kleptog@svana.org>)
Re: "out of memory" error  (Christian Schröder <cs@deriva.de>)
List pgsql-general


On 8/23/07, Martijn van Oosterhout <kleptog@svana.org> wrote:

You've got it completely wrong. By setting shared_buffers to 2GB it
means no-one can use it. It's not postgres that's running out of
memory, it's the rest of your system. Set it to something sane like
128MB or maybe smaller.


Isn't 128MB quite low considering the "current standard" of 25% - 50% of total ram?

Regards

MP


pgsql-general by date:

Previous
From: Mark
Date:
Subject: pgsql functions: get column headers; optional arguments
Next
From: "andrew quaresma"
Date:
Subject: cant get spatial data..