Hello List,

postgres 8.2 is not doing too much but eating up all my memory:
http://pastebin.com/m4cf22ee2
The postgresql.conf is at the very bottom of the pastebin.

I guess this is a configuration issue. The CPUs are almost 100% idle
but i seem to run out of memory.

Any idea what i could do here?

Cheers,
Mario

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--000e0cd488b25e5da1047119e1c6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Parameters like shared_buffers, work_mem are the ones you'll probably need
to adjust.

Work_mem is per user, and can actually be multiples per user, depending on
what you're doing.

On Fri, Aug 14, 2009 at 9:04 AM, ml ml <mliebherr99 [at] googlemail.com> wrote:

> Hello List,
>
> postgres 8.2 is not doing too much but eating up all my memory:
> http://pastebin.com/m4cf22ee2
> The postgresql.conf is at the very bottom of the pastebin.
>
> I guess this is a configuration issue. The CPUs are almost 100% idle
> but i seem to run out of memory.
>
> Any idea what i could do here?
>
> Cheers,
> Mario
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>



--
Peter Steinheuser
psteinheuser [at] myyearbook.com

--000e0cd488b25e5da1047119e1c6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Parameters like shared_buffers, work_mem are the ones you'll probably n=
eed to adjust.<br><br>Work_mem is per user, and can actually be multiples p=
er user, depending on what you're doing.<br><br><div class=3D"gmail_quo=
te">
On Fri, Aug 14, 2009 at 9:04 AM, ml ml <span dir=3D"ltr"><<a href=3D"mai=
lto:mliebherr99 [at] googlemail.com">mliebherr99 [at] googlemail.com</a>></span> w=
rote:<br><blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid =
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello List,<br>
<br>
postgres 8.2 is not doing too much but eating up all my memory:<br>
<a href=3D"http://pastebin.com/m4cf22ee2" target=3D"_blank">http://pastebin=
..com/m4cf22ee2</a><br>
The postgresql.conf is at the very bottom of the pastebin.<br>
<br>
I guess this is a configuration issue. The CPUs are almost 100% idle<br>
but i seem to run out of memory.<br>
<br>
Any idea what i could do here?<br>
<br>
Cheers,<br>
Mario<br>
<font color=3D"#888888"><br>
--<br>
Sent via pgsql-admin mailing list (<a href=3D"mailto:pgsql-admin [at] postgresql=
..org">pgsql-admin [at] postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" target=3D"_blank=
">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>Peter Steinheuse=
r<br><a href=3D"mailto:psteinheuser [at] myyearbook.com">psteinheuser [at] myyearbook=
..com</a><br>

--000e0cd488b25e5da1047119e1c6--

Peter Steinheuser <psteinheuser [at] myyearbook.com> writes:
> Parameters like shared_buffers, work_mem are the ones you'll probably need
> to adjust.

> Work_mem is per user, and can actually be multiples per user, depending on
> what you're doing.

temp_buffers is per-process too --- if there's heavy use of temp tables
in this application, that could be the problem.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Fri, Aug 14, 2009 at 7:04 AM, ml ml<mliebherr99 [at] googlemail.com> wrote:
> Hello List,
>
> postgres 8.2 is not doing too much but eating up all my memory:
> http://pastebin.com/m4cf22ee2
> The postgresql.conf is at the very bottom of the pastebin.
>
> I guess this is a configuration issue. The CPUs are almost 100% idle
> but i seem to run out of memory.
>
> Any idea what i could do here?

Post what has been changed from the defaults on postgresql.conf. I'm
guessing work_mem is a little big, but that's just a guess.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Oh I see that work_mem etc are in the pastebin. Yeah, 128M is pretty
high work_mem if all 75 connections are working hard that's 9.6Gig of
ram. which you haven't got.

On Fri, Aug 14, 2009 at 2:03 PM, Scott Marlowe<scott.marlowe [at] gmail.com> wrote:
> On Fri, Aug 14, 2009 at 7:04 AM, ml ml<mliebherr99 [at] googlemail.com> wrote:
>> Hello List,
>>
>> postgres 8.2 is not doing too much but eating up all my memory:
>> http://pastebin.com/m4cf22ee2
>> The postgresql.conf is at the very bottom of the pastebin.
>>
>> I guess this is a configuration issue. The CPUs are almost 100% idle
>> but i seem to run out of memory.
>>
>> Any idea what i could do here?
>
> Post what has been changed from the defaults on postgresql.conf. I'm
> guessing work_mem is a little big, but that's just a guess.
>



--
When fascism comes to America, it will be intolerance sold as diversity.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin