Seems OK for PostgreSQL. You should also take into account the requirements
of the other applications on that server too (if any).
Actually it's 5 000 000 000 < 2097152 * 4096 == 8 589 934 592. Which is OK.
You can use ipcs monitor the allocated shared memory segments and their
actual size.
http:
Thanks, I've put (for my 16GB RAM / 64 bit machine)
into /etc/sysctl.conf: kernel.shmmax = 50
And into postgresql.conf: shared_buffers = 4096MB
I didn't change shmall from the default -
# sysctl -A|grep shm
kernel.shmmax = 50
kernel.shmall = 2097152
kernel.shmmni = 4096
because
Alexander Farber wrote:
> Hello again,
>
> on CentOS 6 / 64 bit what is please the best way
> to permanently increase the shared memory?
>
> I'd like to give shared_buffers = 4096MB
> to PostgreSQL 8.4 on my machine with
> 16 GB RAM, but I currently only have:
>
># sysctl -A|grep shm
>kerne
* shmall is total for all processes (in pages)
* shmmax is the maximum size of single contiguous shared memory segment (in
bytes)
Both should be tuned to be large enough (obviously shmmax should be able to
fit into shmall)
If the memory is locked you may need to tune /etc/security/limits.conf too
On 10/04/11 8:45 AM, Alexander Farber wrote:
> on CentOS 6 / 64 bit what is please the best way
> to permanently increase the shared memory?
/etc/sysctl.conf
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
__
Hello again,
on CentOS 6 / 64 bit what is please the best way
to permanently increase the shared memory?
I'd like to give shared_buffers = 4096MB
to PostgreSQL 8.4 on my machine with
16 GB RAM, but I currently only have:
# sysctl -A|grep shm
kernel.shmmax = 33554432
kernel.shmall = 2097
6 matches
Mail list logo
