Re: Postgres is eating up all my memory
От | Scott Marlowe |
---|---|
Тема | Re: Postgres is eating up all my memory |
Дата | |
Msg-id | dcc563d10908141306o36286ec0tdc7f1f41d0e79642@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Postgres is eating up all my memory (Scott Marlowe <scott.marlowe@gmail.com>) |
Список | 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@gmail.com> wrote: > On Fri, Aug 14, 2009 at 7:04 AM, ml ml<mliebherr99@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.
В списке pgsql-admin по дате отправления: