Re: default resource limits - Mailing list pgsql-patches

From daveg
Subject Re: default resource limits
Date
Msg-id 20051223222256.GA28050@sonic.net
Whole thread Raw
In response to default resource limits  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: default resource limits  (Andrew Dunstan <andrew@dunslane.net>)
Re: default resource limits  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@sonic.net
If simplicity worked, the world would be overrun with insects.

pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: default resource limits
Next
From: Andrew Dunstan
Date:
Subject: Re: default resource limits