Josh Berkus <josh@agliodbs.com> writes:
> The other thing which will avoid the problem for most Mac users is if we
> simply allocate 10% of RAM at initdb as a default. If we do that, then
> 90% of users will never touch Shmem themselves, and not have the
> opportunity to mess up.
If we could do that on *all* platforms, I might be for it, but we only
know how to get that number on some platforms. There's also the issue
of whether we really want to assume that the machine is dedicated to
Postgres, which IMO is an implicit assumption of any default that scales
itself to physical RAM.
For the moment I think we should just allow initdb to scale up a little
bit more than where it is now, perhaps 128MB instead of 32.
regards, tom lane