requested shared memory size overflows size_t

Поиск
Список
Период
Сортировка
От Yuri Levinsky
Тема requested shared memory size overflows size_t
Дата
Msg-id C9278837BA426D4DBDF8996DB8902326128E0E@Cobra.celltick.com
обсуждение исходный текст
Ответы Re: requested shared memory size overflows size_t  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
<div class="WordSection1"><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:black">Dear
Developers,</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">Please help with the
followingproblem. I am running PostgreSQL 9.2.3 on SUN Solaris 9. This is 64 bit system with 32G swap and 16G RAM. I
usesame configuration file as on Linux or SUN Solaris 10, where everything is ok. I am unable to set shared buffer 5G,
themaximum possible value is 4G. When I decrease the configuration parameters and start the instance successfully: some
queriesfails on "out of memory" error. I verified kernel parameters: they looks same as on Solaris 10 and big enough.
Theonly one difference is: Solaris 9 PostgreSQL version, in opposite to Solaris 10 and Linux,  was compiled by me with
defaultoptions. </span><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:black">My kernel
is:</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">set
semsys:seminfo_semmap=64</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">set
semsys:seminfo_semmni=4096</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">set
semsys:seminfo_semmns=4096</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">set
semsys:seminfo_semmnu=4096</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">set
semsys:seminfo_semume=64</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">set
semsys:seminfo_semmsl=500</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">set
shmsys:shminfo_shmmax=0xffffffffffff</span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">setshmsys:shminfo_shmmin=100</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">setshmsys:shminfo_shmmni=4096</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">setshmsys:shminfo_shmseg=100</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black"> </span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">Config.</span><pclass="MsoNormal">shared_buffers = 3GB<p
class="MsoNormal">temp_buffers= 2GB <p class="MsoNormal">work_mem = 1024MB<span
style="font-family:"Georgia","serif";color:black"></span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black"> </span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black"> </span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black"> </span><pclass="MsoNormal"><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#111111">Sincerelyyours</span></i><span
style="color:black">,</span><pclass="MsoNormal"><span style="color:black"> </span><p class="MsoNormal"><span
style="color:black"><imgalt="Description: Celltick logo_highres" height="59" id="Picture_x0020_1"
src="cid:image002.jpg@01CF37A1.222583E0"width="161" /></span><p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black">YuriLevinsky, DBA</span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"></span><pclass="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black">CelltickTechnologies Ltd., 32 Maskit St., Herzliya
46733,Israel</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"></span><p
class="MsoNormal"><spanstyle="font-size:8.0pt;font-family:"Arial","sans-serif";color:black">Mobile: +972 54 6107703,
Office:+972 9 9710239; Fax: +972 9 9710222</span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"></span><pclass="MsoNormal"> </div> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: UNION ALL on partitioned tables won't use indices.
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: jsonb and nested hstore