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
