Re: Posix Shared Mem patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Posix Shared Mem patch
Date
Msg-id 26786.1340990927@sss.pgh.pa.us
Whole thread Raw
In response to Re: Posix Shared Mem patch  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Posix Shared Mem patch  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: change_varattnos_of_a_node versus whole-row Vars
Next
From: Josh Berkus
Date:
Subject: Re: Posix Shared Mem patch