Skip site navigation (1) Skip section navigation (2)

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: 2005-12-23 22:22:56
Message-ID: 20051223222256.GA28050@sonic.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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.

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-12-23 22:25:55
Subject: Re: Questions related to xlog
Previous:From: Jonah H. HarrisDate: 2005-12-23 22:14:48
Subject: Re: Oracle PL/SQL Anonymous block equivalent in postgres

pgsql-patches by date

Next:From: Andrew DunstanDate: 2005-12-23 23:20:06
Subject: Re: default resource limits
Previous:From: Andrew DunstanDate: 2005-12-23 20:50:10
Subject: Re: default resource limits

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group