| From: | Sean Chittenden <seanc(at)joyent(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | stadtkind2(at)gmx(dot)de, Sam Gwydir <sam(dot)gwydir(at)joyent(dot)com>, Sean Chittenden <sean(at)chittenden(dot)org>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: [PATCH] BUG #13416: Postgres =?utf-8?Q?>=3D_?=9.3 doesn't use optimized shared memory on Solaris anymore |
| Date: | 2017-10-03 23:11:57 |
| Message-ID: | f2ba267d-3a6d-4ffb-b842-9d6d1c0b3b1e@Spark |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
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
seanc(at)joyent(dot)com
| Attachment | Content-Type | Size |
|---|---|---|
| ism.patch | application/octet-stream | 3.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2017-10-03 23:53:41 | Re: [HACKERS] BUG #14825: enum type: unsafe use? |
| Previous Message | John R Pierce | 2017-10-03 22:00:47 | Re: BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petr Jelinek | 2017-10-03 23:35:29 | Re: Issues with logical replication |
| Previous Message | Peter Geoghegan | 2017-10-03 23:10:20 | Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple |