From: | Yuri Levinsky <yuril(at)celltick(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | requested shared memory size overflows size_t |
Date: | 2014-03-04 09:59:02 |
Message-ID: | C9278837BA426D4DBDF8996DB8902326128E0E@Cobra.celltick.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dear Developers,
Please help with the following problem. I am running PostgreSQL 9.2.3 on SUN Solaris 9. This is 64 bit system with 32G swap and 16G RAM. I use same configuration file as on Linux or SUN Solaris 10, where everything is ok. I am unable to set shared buffer 5G, the maximum possible value is 4G. When I decrease the configuration parameters and start the instance successfully: some queries fails on "out of memory" error. I verified kernel parameters: they looks same as on Solaris 10 and big enough. The only one difference is: Solaris 9 PostgreSQL version, in opposite to Solaris 10 and Linux, was compiled by me with default options.
My kernel is:
set semsys:seminfo_semmap=64
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=64
set semsys:seminfo_semmsl=500
set shmsys:shminfo_shmmax=0xffffffffffff
set shmsys:shminfo_shmmin=100
set shmsys:shminfo_shmmni=4096
set shmsys:shminfo_shmseg=100
Config.
shared_buffers = 3GB
temp_buffers = 2GB
work_mem = 1024MB
Sincerely yours,
[Description: Celltick logo_highres]
Yuri Levinsky, DBA
Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel
Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2014-03-04 10:07:07 | Re: jsonb and nested hstore |
Previous Message | Kyotaro HORIGUCHI | 2014-03-04 09:57:56 | Re: UNION ALL on partitioned tables won't use indices. |