From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: default resource limits |
Date: | 2005-12-12 15:06:21 |
Message-ID: | 1779.1134399981@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> 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.
I don't mind having initdb try larger values to see if they work, but
if you are suggesting that we try to force adoption of larger settings
I'll resist it.
"Factor of three" seems mighty weird. The existing numbers (100 and 1000)
at least have the defensibility of being round.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-12-12 15:11:12 | Re: Backslashes in string literals |
Previous Message | Tom Lane | 2005-12-12 15:00:16 | Re: Different length lines in COPY CSV |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-12-12 15:13:13 | Re: farsi translation of postgresql FAQ updated |
Previous Message | Andrew Dunstan | 2005-12-12 14:55:59 | Re: farsi translation of postgresql FAQ updated |