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: (view raw or whole 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.


David Gould                      daveg(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.

In response to


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-2015 The PostgreSQL Global Development Group