Re: default resource limits
- From: daveg <daveg(at)sonic(dot)net>
- To: Andrew Dunstan <andrew(at)dunslane(dot)net>
- Cc: "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
- Subject: Re: default resource limits
- Date: Fri, 23 Dec 2005 14:22:56 -0800
- Message-id: <20051223222256.GA28050@sonic.net> <text/plain>
On Fri, Dec 23, 2005 at 03:38:56PM -0500, Andrew Dunstan wrote:
> >
> >What numbers would you like? If what I suggested seems odd, how about
> >targets of 400 connections, 4000 shared_buffers and 200,000
> >max_fsm_pages?
>
>
> Here's a patch that does what I had in mind. On my modest workstation it
> tops out at 400 connections and 2500/125000
> shared_buffers/max_fsm_pages. An idle postmaster with these settings
> consumed less than 4% of the 380Mb of memory, according to top, making
> it still dwarfed by X, mozilla, apache and amavisd among other memory hogs.
I don't understand the motivation for so many connections by default, it
seems wasteful in most cases.
-dg
--
David Gould daveg(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.
Home |
Main Index |
Thread Index