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@xxxxxxxxx> wrote: > On Fri, Aug 14, 2009 at 7:04 AM, ml ml<mliebherr99@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
