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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Fri, 23 Dec 2005 14:22:56 -0800
  • Message-id: <20051223222256.GA28050@sonic.net> <text/plain>

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.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group