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