Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Greg Smith
On 05/02/2011 12:53 AM, Adarsh Sharma wrote: I am also in need of a proper documentation that explains how to set SHMAX and SHMALL variables in Postgres. What things need to be taken in consideration before doing that ? What is the value of SHMAX & SHMALL if u have 16 GB RAM for Postgres Serv

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Adarsh Sharma
Tomas Vondra wrote: Dne 2.5.2011 06:53, Adarsh Sharma napsal(a): I am also in need of a proper documentation that explains how to set SHMAX and SHMALL variables in Postgres. What things need to be taken in consideration before doing that ? What is the value of SHMAX & SHMALL if u have 16 GB

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Tomas Vondra
Dne 2.5.2011 06:53, Adarsh Sharma napsal(a): > I am also in need of a proper documentation that explains how to set > SHMAX and SHMALL variables in Postgres. > > What things need to be taken in consideration before doing that ? > What is the value of SHMAX & SHMALL if u have 16 GB RAM for Postgre

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Mark Kirkwood
On 01/05/11 18:48, Phoenix Kiula wrote: Now, according to my reading in the PG manual and this list, a good recommended value for SHMMAX is (shared_buffers * 8192) My postgresql.conf settings at the moment are: max_connections = 300 shared_buffers = 300MB effective_cache_siz

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-01 Thread Adarsh Sharma
I am also in need of a proper documentation that explains how to set SHMAX and SHMALL variables in Postgres. What things need to be taken in consideration before doing that ? What is the value of SHMAX & SHMALL if u have 16 GB RAM for Postgres Server ? Thanks Phoenix Kiula wrote: Hi. I'm

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-01 Thread Greg Smith
On 05/01/2011 02:48 AM, Phoenix Kiula wrote: Hi. I'm on a 64 Bit CentOS 5 system, quadcore processor, 8GB RAM and tons of data storage (1 TB SATAII disks). The current SHMMAX and SHMMIN are (commas added for legibility) -- kernel.shmmax = 68,719,476,736 kernel.shmall = 4,294,967,296 That'

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-01 Thread Kevin Grittner
Phoenix Kiula wrote: > Now, according to my reading in the PG manual and this list, a > good recommended value for SHMMAX is > >(shared_buffers * 8192) Where did you see that? The amount of data buffered is the number of shared buffers * 8KB. Taking shared_buffers as a number of bytes a

[PERFORM] The right SHMMAX and FILE_MAX

2011-04-30 Thread Phoenix Kiula
Hi. I'm on a 64 Bit CentOS 5 system, quadcore processor, 8GB RAM and tons of data storage (1 TB SATAII disks). The current SHMMAX and SHMMIN are (commas added for legibility) -- kernel.shmmax = 68,719,476,736 kernel.shmall = 4,294,967,296 Now, according to my reading in the PG manual and this li