[HACKERS] Re: [PATCH] BUG #13416: Postgres >= 9.3 doesn't use optimized shared memory on Solaris anymore
Hello. We identified the same problem. Sam Gwydir and Josh Clulow were able to put together the appropriate fix after. The breakage in src/backend/port/sysv_shmem.c and src/include/storage/dsm_impl.h should be back ported to all supported versions (the regression was introduced between the 9.2 and 9.3 branches). The only real question remaining is: do we want to change the default behavior, as detected by initdb(1), to use ISM on Illumos/Solaris derived systems? Given the memory bloat experienced when using POSIX shared memory (potentially very significant for systems with larger shared_buffers), we think it's probably prudent to change the default from dynamic_shared_memory_type=posix to sysv. Unfortunately I think it's not worth changing the default behavior of initdb(1) in the current supported branches, but it should be changed for 10. Please let us know if there are any questions. -sc -- Sean Chittenden se...@joyent.com
[HACKERS] Re: [PATCH] BUG #13416: Postgres >= 9.3 doesn't use optimized shared memory on Solaris anymore
Hello. We identified the same problem. Sam Gwydir and Josh Clulow were able to put together the appropriate fix after. The breakage in src/backend/port/sysv_shmem.c and src/include/storage/dsm_impl.h should be back ported to all supported versions (the regression was introduced between the 9.2 and 9.3 branches). The only real question remaining is: do we want to change the default behavior, as detected by initdb(1), to use ISM on Illumos/Solaris derived systems? Given the memory bloat experienced when using POSIX shared memory (potentially very significant for systems with larger shared_buffers), we think it's probably prudent to change the default from dynamic_shared_memory_type=posix to sysv. Unfortunately I think it's not worth changing the default behavior of initdb(1) in the current supported branches, but it should be changed for 10. Please let us know if there are any questions. -sc -- Sean Chittenden se...@joyent.com ism.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
