On Feb 6, 2013, at 5:58 PM, Mel Llaguno wrote:
> Any pointers which would explain these differences would be greatly
> appreciate.
Postgres is likely not the only thing on your system that allocates shared
memory.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 72
's
> suggestion, I'm having a look at the src/backend/storage/ipc/ipci.c.
>
> Thanks,
>
> Mel
>
> From: Tom Lane [t...@sss.pgh.pa.us]
> Sent: Wednesday, February 06, 2013 10:49 PM
> To: Mel Llaguno
> Cc: Pavan Deolasee;
MIN] PostgreSQL's share_buffer calculation using shmget()
versus kernel.shmmax
Mel Llaguno writes:
> Thanks for your reply. I agree with your statement that you should set the
> configuration parameters first, but I would like to be able to calculate the
> SHMMAX value based on those
Mel Llaguno writes:
> Thanks for your reply. I agree with your statement that you should set the
> configuration parameters first, but I would like to be able to calculate the
> SHMMAX value based on those parameters. This is particularly useful when
> suggesting postgresql.conf optimizations t
Pavan,
Thanks. I'll have a look at the source code.
M.
From: Pavan Deolasee [pavan.deola...@gmail.com]
Sent: Wednesday, February 06, 2013 10:41 PM
To: Mel Llaguno
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PostgreSQL's share_buffer c
On Thu, Feb 7, 2013 at 11:01 AM, Mel Llaguno wrote:
> Having to guess this value is far from ideal; what I'd like is the formula
> used by postgresql that generates the shmget() value displayed in the
> pgctl.log.
>
There is no easy way or at least none that I'm aware of, to get the
exact value
l.com]
Sent: Wednesday, February 06, 2013 10:12 PM
To: Mel Llaguno
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PostgreSQL's share_buffer calculation using shmget()
versus kernel.shmmax
On Thu, Feb 7, 2013 at 6:28 AM, Mel Llaguno wrote:
> All,
>
> I'm wondering about how p
On Thu, Feb 7, 2013 at 6:28 AM, Mel Llaguno wrote:
> 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/
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`
ph
