Here's some things contributors have already adjusted:
- shared_buffers now goes up to 128MB automatically depending on available RAM reservation (we did this for 9.3)
- effective_cache_size is automatically set to shared_buffers X 3 (might be X 4 by the time we release)
However, one thing which came up during this discussion is that many people may be running PostgreSQL on virtual machines which have less than 1GB of RAM available to PostgreSQL. I don't think they are, but we lack data. So I put up a survey to see what amounts of RAM our users really have on their smallest machines/VMs. Please fill out the survey so that we can have reasonable input for development, and if you have comments, please put them below.