| From: | Mel Llaguno <mllaguno(at)coverity(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax |
| Date: | 2013-02-07 00:58:50 |
| Message-ID: | E1FB7FBAE29E634FA58D6CC0D59F288B11EF7329@CH1PRD0511MB442.namprd05.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
All,
I'm wondering about how postgresql calculates the value for shared buffers as I see some discrepancies with what the following script provides versus what is recommended in the pgctl.log when the database fails to start.
#!/bin/bash
# simple shmsetup script
page_size=`getconf PAGE_SIZE`
phys_pages=`getconf _PHYS_PAGES`
shmall=`expr $phys_pages / 2`
shmmax=`expr $shmall \* $page_size`
echo kernel.shmmax = $shmmax
echo kernel.shmall = $shmall
Any pointers which would explain these differences would be greatly appreciate. Ultimately, I'd like to calculate the expected kernel.shmmax which matches postgresql's shmget() call.
TIA,
Mel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2013-02-07 05:12:49 | Re: PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax |
| Previous Message | Dev Kumkar | 2013-02-06 20:18:01 | Re: Facing authentication error on postgres 9.2 -> dblink functions |