Josh Berkus <josh@xxxxxxxxxxxx> writes: >> Well, we're not going to increase the default to gigabytes, but we could >> very probably increase it by a factor of 10 or so without anyone >> squawking. It's been awhile since I heard of anyone trying to run PG in >> 4MB shmmax. How much would a change of that size help? > Last I checked, though, this comes out of the allocation available to > shared_buffers. And there definitely are several OSes (several linuxes, > OSX) still limited to 32MB by default. Sure, but the current default is a measly 64kB. We could increase that 10x for a relatively small percentage hit in the size of shared_buffers, if you suppose that there's 32MB available. The current default is set to still work if you've got only a couple of MB in SHMMAX. What we'd want is for initdb to adjust the setting as part of its probing to see what SHMMAX is set to. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
