Re: recommendations for reducing mem usage on local dev machine

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

> 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?

Thanks for your advice Tom. And you are probably right - at work with
1.5gig I can even get this + VS2005 + EntMan 2005 open without it
starting to swap. I have had nasty experiences running eclipse in both
Gentoo and Fedora (even though the production environment is Suse, so
it might even make more sense), and with KDE/Gnome these days, I don't
think there is much difference with XP...
I guess I'm just waiting till a system with native virtualisation (no
more reboots!) and enough memory comes into my price range before
doing an upgrade :-).
Thanks - I'll just have to keep my open apps to a minimum!
Cheers
Anton

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anton Melser 2007-04-14 16:35:40 Re: question
Previous Message Tom Lane 2007-04-14 16:19:35 Re: error creating/setting sequence, pg_dump / pg_restore 8.1.5