Обсуждение: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Hi I just installed an openSUSE 12.3 64Bit on an i5 box with 32GB RAM. Then I installed postgresql 9.2.4 from their repository. The pg service starts with default config. As default it has only 24 MB shared_buffers. I need it way higher like 4 or even 8 GB. As soon I change those 24 MB to something higher, PG won't start anymore. I had the same issue back with openSUSE 12.1 and it was solved when I switched from systemd back to sysvinit. How can I get more memory for PG on openSUSE 12.3 ? Regards Andreas
On Fri, Jun 14, 2013 at 11:55 AM, Andreas <maps.on@gmx.net> wrote: > How can I get more memory for PG on openSUSE 12.3 ? http://www.postgresql.org/docs/9.2/static/kernel-resources.html -- Regards, Peter Geoghegan
Am 14.06.2013 20:55, schrieb Peter Geoghegan: > On Fri, Jun 14, 2013 at 11:55 AM, Andreas <maps.on@gmx.net> wrote: >> How can I get more memory for PG on openSUSE 12.3 ? > http://www.postgresql.org/docs/9.2/static/kernel-resources.html > > OK I think that did it :) I'm just wondering what point it could be to set the default limits so low in the first place as plenty of memory is so common these days. regards Andreas
On 06/14/2013 01:47 PM, Andreas wrote: > > Am 14.06.2013 20:55, schrieb Peter Geoghegan: >> On Fri, Jun 14, 2013 at 11:55 AM, Andreas <maps.on@gmx.net> wrote: >>> How can I get more memory for PG on openSUSE 12.3 ? >> http://www.postgresql.org/docs/9.2/static/kernel-resources.html >> >> > > OK I think that did it :) > > I'm just wondering what point it could be to set the default limits so > low in the first place as plenty of memory is so common these days. The type of shared memory postgresql uses is rarely used by other systems. However, as I recall 9.3 resolves the shmmax issue as a whole so it won't be a problem. jD > > > regards > Andreas > > -- Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc For my dreams of your image that blossoms a rose in the deeps of my heart. - W.B. Yeats
On Sat, Jun 15, 2013 at 5:46 AM, Joshua D. Drake <jd@commandprompt.com> wrote:
-- The type of shared memory postgresql uses is rarely used by other systems. However, as I recall 9.3 resolves the shmmax issue as a whole so it won't be a problem.
Yes, by reducing system v shared memory consumption:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0fc0df9364d2d2d17c0162cf3b8b59f6cb09f67
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0fc0df9364d2d2d17c0162cf3b8b59f6cb09f67
This single commit has removed years of pain for many users.
Michael