| From: | Ilya Kosmodemiansky <ilya(dot)kosmodemiansky(at)postgresql-consulting(dot)com> |
|---|---|
| To: | Alexey Vasiliev <leopard_ne(at)inbox(dot)ru> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Why shared_buffers max is 8GB? |
| Date: | 2014-03-26 12:35:15 |
| Message-ID: | CAG95seUecSzUMEcB19X=RZ+=zfyFg01jSxf_nckwAvKV3ApSUg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi Alexey,
On Wed, Mar 26, 2014 at 1:21 PM, Alexey Vasiliev <leopard_ne(at)inbox(dot)ru> wrote:
> I read from several sources, what maximum shared_buffers is 8GB.
I believe that was an issue on some older versions, and thats why was
mentioned in several talks. Today it is a sort of apocrypha.
> Does this true? If yes, why exactly this number is maximum number of
> shared_buffers for good performance (on Linux 64-bits)?
25% of available RAM is a good idea to start. Sometimes, if you have
heavy workload _and_ it is possible to reside whole database in
memory, better to use something larger, about ~75% of RAM.
Best regards,
Ilya
--
Ilya Kosmodemiansky,
PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik(at)postgresql-consulting(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | desmodemone | 2014-03-26 12:45:15 | Re: Why shared_buffers max is 8GB? |
| Previous Message | Alexey Vasiliev | 2014-03-26 12:21:51 | Why shared_buffers max is 8GB? |