On Thu, Oct 10, 2013 at 1:23 AM, Magnus Hagander <mag...@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). > > 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 for all of that. I completely agree. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
