Re: recommendations for reducing mem usage on local dev machine

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
Cc: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: recommendations for reducing mem usage on local dev machine
Date: 2007-04-14 16:06:26
Message-ID: 4664.1176566786@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Anton Melser" <melser(dot)anton(at)gmail(dot)com> writes:
> I am stuck for the moment with 1gig of ram on a win xp machine running
> a 8.2.3 postgres. With the java website taking 300meg, eclipse taking
> 250meg+, firefox 150meg+, all of which are going to be nasty to reduce
> the mem usage of, I am looking at reducing postgres usage (the java
> website runs on postgres). The db is not really a bottleneck for
> development, so I am not concerned about reducing things very low. At
> the moment I have around 10 postgres processes in the taskmanager, 5
> of which are taking around 40meg.

It's fairly likely that that report is misleading: most Unix versions
of "top" report Postgres' shared memory as belonging to *each* backend,
and I'll bet taskmanager is doing the same thing. You could reduce
shared memory usage (cut shared_buffers in particular), which might make
the reported usage drop to say 20mb per process, but you only saved
20mb not 20*5.

It sounds to me like you're simply wishing for more than your box can
handle. Have you thought about running the client and server parts of
your development on separate boxes? Or maybe install an OS with less
overhead than Windoze?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alain Roger 2007-04-14 16:11:05 postgresql 8.1.4 to 8.2.3
Previous Message Anton Melser 2007-04-14 13:47:33 Re: recommendations for reducing mem usage on local dev machine