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