| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Andreas <maps(dot)on(at)gmx(dot)net>, 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: [GENERAL] Can't increase shared_buffers for PostgreSQL on openSUSE 12.3 |
| Date: | 2013-06-15 01:46:16 |
| Message-ID: | CAB7nPqQs41JE3cva1j6ZB-AmTC6sebQJ-o2OE=2wU7OwrrGZ7Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Sat, Jun 15, 2013 at 5:46 AM, Joshua D. Drake <jd(at)commandprompt(dot)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
This single commit has removed years of pain for many users.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2013-06-16 03:03:13 | Re: pg_upgrade with -j shows no perf improvement |
| Previous Message | Lonni J Friedman | 2013-06-14 21:29:24 | pg_upgrade with -j shows no perf improvement |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Balmer | 2013-06-15 08:37:50 | Dynamic SQL in Lua |
| Previous Message | Moshe Jacobson | 2013-06-14 21:25:48 | could not write to hash-join temporary file: No space left on device |