default resource limits

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: default resource limits
Date: 2005-12-12 14:46:22
Message-ID: 439D8D3E.8020607@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


The discussion was a bit inconclusive last time, so I would like to
renew my proposal for more generous default resource limits.

Nearly everyone seems to agree that the default for max_fsm_pages is
woefully low, so I would like to have the default for this set
unconditionally to 200,000 rather than 20,000. The cost would be just
over 1Mb of shared memory, if the docs are correct. Alternatively, we
could put this into the mix that is calculated by initdb, scaling it
linearly with shared_buffers (but with the default still at 200,000).

I would also like to propose a more modest increase in max_connections
and shared_buffers by a factor of 3. This number is picked with some
caution, and is intended to ensure that a) we don't eat all the
resources on a modestly resourced machine, and b) we can accomodate 1
connection per apache child in a typical (unix) apache configuration. If
we were slightly less conservative, we'd at least take default
max_connections to 400, which is the maximum number of apache threads on
Windows, in the default configuration.)

Since the time when these defaults were set, the price of memory has
plummeted, and the typical memory population of an entry level machine
has roughly quadrupled, from my observation, so it seems to me that by
revising these limits we are just adjusting to the new reality.

cheers

andrew

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2005-12-12 14:52:20 Re: Backslashes in string literals
Previous Message Alvaro Herrera 2005-12-12 14:02:50 Re: Reducing relation locking overhead

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2005-12-12 14:55:59 Re: farsi translation of postgresql FAQ updated
Previous Message Bruce Momjian 2005-12-12 14:18:33 Re: [PATCHES] a tutorial for postgresql in farsi,