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: | 2005-12-23 22:22:56 |
Message-ID: | 20051223222256.GA28050@sonic.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-23 22:25:55 | Re: Questions related to xlog |
Previous Message | Jonah H. Harris | 2005-12-23 22:14:48 | Re: Oracle PL/SQL Anonymous block equivalent in postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2005-12-23 23:20:06 | Re: default resource limits |
Previous Message | Andrew Dunstan | 2005-12-23 20:50:10 | Re: default resource limits |