| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] default resource limits |
| Date: | 2005-12-26 22:49:29 |
| Message-ID: | 43B07378.7080002@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
>>Leaving aside the question of max_connections, which seems to be the
>>most controversial, is there any objection to the proposal to increase
>>the settings tried for shared_buffers (up to 4000) and max_fsm_pages (up
>>to 200000) ? If not, I'll apply a patch for those changes shortly.
>>
>>
>
>You probably need to fix the max-connections pass so that it applies the
>same changes to max_fsm_pages as the second pass does --- otherwise, its
>assumption that shared_buffers can really be set that way will be wrong.
>Other than that I didn't see any problem with the shared_buffers part of
>the patch.
>
>
>
>
revised patch attached, leaving max_connections alone except as above.
I'll apply this in a day or two, barring objection.
cheers
andrew
| Attachment | Content-Type | Size |
|---|---|---|
| shbuf.diff | text/x-patch | 4.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-27 00:01:07 | Re: Case Conversion Functions |
| Previous Message | Martijn van Oosterhout | 2005-12-26 21:47:57 | Re: Fixing row comparison semantics |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-12-27 03:24:40 | Re: [BUGS] BUG #2114: (patch) COPY FROM ... end of copy marker corrupt |
| Previous Message | Heikki Linnakangas | 2005-12-26 19:46:44 | Re: [HACKERS] Online backup vs Continuous backup |