pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't increase shared_buffers for PostgreSQL on openSUSE 12.3
5+ messages / 4 participants
[nested] [flat]
* Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
@ 2013-06-14 18:55 Andreas <maps.on@gmx.net>
0 siblings, 1 reply; 5+ messages in thread
From: Andreas @ 2013-06-14 18:55 UTC (permalink / raw)
To: PostgreSQL <pgsql-general@postgresql.org>; pgsql-admin
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-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
@ 2013-06-14 18:55 Peter Geoghegan <peter.geoghegan86@gmail.com>
parent: Andreas <maps.on@gmx.net>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Geoghegan @ 2013-06-14 18:55 UTC (permalink / raw)
To: Andreas <maps.on@gmx.net>; +Cc: PostgreSQL <pgsql-general@postgresql.org>; pgsql-admin
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
@ 2013-06-14 20:46 Joshua D. Drake <jd@commandprompt.com>
parent: Andreas <maps.on@gmx.net>
0 siblings, 1 reply; 5+ messages in thread
From: Joshua D. Drake @ 2013-06-14 20:46 UTC (permalink / raw)
To: Andreas <maps.on@gmx.net>; +Cc: Peter Geoghegan <peter.geoghegan86@gmail.com>; PostgreSQL <pgsql-general@postgresql.org>; pgsql-admin
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
@ 2013-06-14 20:47 Andreas <maps.on@gmx.net>
parent: Peter Geoghegan <peter.geoghegan86@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Andreas @ 2013-06-14 20:47 UTC (permalink / raw)
To: Peter Geoghegan <peter.geoghegan86@gmail.com>; +Cc: PostgreSQL <pgsql-general@postgresql.org>; pgsql-admin
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [GENERAL] Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
@ 2013-06-15 01:46 Michael Paquier <michael.paquier@gmail.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Paquier @ 2013-06-15 01:46 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Andreas <maps.on@gmx.net>; Peter Geoghegan <peter.geoghegan86@gmail.com>; PostgreSQL <pgsql-general@postgresql.org>; pgsql-admin
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=b0fc0df9364d2d2d17c0162cf3b8b59f6cb09f...
This single commit has removed years of pain for many users.
--
Michael
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2013-06-15 01:46 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-06-14 18:55 Can't increase shared_buffers for PostgreSQL on openSUSE 12.3 Andreas <maps.on@gmx.net>
2013-06-14 18:55 ` Peter Geoghegan <peter.geoghegan86@gmail.com>
2013-06-14 20:47 ` Andreas <maps.on@gmx.net>
2013-06-14 20:46 ` Joshua D. Drake <jd@commandprompt.com>
2013-06-15 01:46 ` Michael Paquier <michael.paquier@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox