Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Date: 2013-06-14 20:46:31
Message-ID: 51BB8127.4030205@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general


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(dot)on(at)gmx(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas 2013-06-14 20:47:16 Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Previous Message Peter Geoghegan 2013-06-14 18:55:53 Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

Browse pgsql-general by date

  From Date Subject
Next Message Andreas 2013-06-14 20:47:16 Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Previous Message Peter Geoghegan 2013-06-14 18:55:53 Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3