Quantcast

Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

Andreas-3-2
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


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Peter Geoghegan
On Fri, Jun 14, 2013 at 11:55 AM, Andreas <[hidden email]> 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


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Andreas-3-2
Am 14.06.2013 20:55, schrieb Peter Geoghegan:
> On Fri, Jun 14, 2013 at 11:55 AM, Andreas <[hidden email]> 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


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Joshua D. Drake

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 <[hidden email]> 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


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Michael Paquier



On Sat, Jun 15, 2013 at 5:46 AM, Joshua D. Drake <[hidden email]> 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.
This single commit has removed years of pain for many users.
--
Michael
Loading...