| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de>, "Shukla, Sumeet" <ShuklaSu(at)advisory(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How should the correct value of shmmax be calculated for DWH (OLAP) server |
| Date: | 2018-10-15 08:21:09 |
| Message-ID: | 54f17ea619c4a0d74f8ecc71d91d8862162aa5c2.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Gunnar "Nick" Bluth wrote:
> Am 15.10.2018 um 09:43 schrieb Laurenz Albe:
> > Shukla, Sumeet wrote:
> >> Can someone please help me determine the appropriate value of kernel shmmax
> >> parameter for PostgreSQL configured for Data Warehouse use?
> >
> > Simple. Set it to anything bigger than your "shared_buffers" setting.
> > If PostgreSQL manages to start, your setting is big enough.
> >
>
> As a matter of fact, you shouldn't need to set SHMMAX anyway, unless you
> tampered with "dynamic_shared_memory_type" or you are on a very exotic
> OS ;-)
True, I was living in the past. Thanks for the correction.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2018-10-15 08:21:40 | Re: pgpool versus which tool? |
| Previous Message | Mark Kirkwood | 2018-10-15 08:16:14 | Re: Commit not required for update statement |