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
On 04/30/2011 09:00 PM, Samuel Gendler wrote:
Some kind of in-memory cache of doc/ad mappings which the ad server
interacts with will serve you in good stead and will be much easier to
scale horizontally than most relational db architectures lend
themselves to...Even something as simple as a pr
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'
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
Qiang Wang wrote:
> We have PostgreSQL 8.3 running on Debian Linux server. We built an
> applicantion using PHP programming language and Postgres database. There are
> appoximatly 150 users using the software constantly. We had some performance
> degration before and after some studies we figured
