Re: Auto-tuning work_mem and maintenance_work_mem - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Auto-tuning work_mem and maintenance_work_mem
Date
Msg-id 20131010123308.GK2706@tamriel.snowman.net
Whole thread Raw
In response to Re: Auto-tuning work_mem and maintenance_work_mem  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
* Magnus Hagander (magnus@hagander.net) wrote:
> I think it would be even simpler, and more reliable, to start with the
> parameter to initdb - I like that. But instead of having it set a new
> variable based on that and then autotune off that, just have *initdb*
> do these calculations you're suggesting, and write new defaults to the
> files (preferably with a comment).

Agreed; I especially like having the comment included.

> That way if the user *later* comes in and say changes shared_buffers,
> we don't dynamically resize the work_mem into a value that might cause
> his machine to die from swapping which would definitely violate the
> principle of least surprise..

+1
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Auto-tuning work_mem and maintenance_work_mem
Next
From: Robert Haas
Date:
Subject: Re: space reserved for WAL record does not match what was written: panic on windows