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