From: Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
To: pgsql-performance@postgresql.org
Subject: Confirm calculus
Date: Wed, 16 Jun 2010 13:45:57 +0000
Message-ID: <20100616191249.D1A2F633B17@mail.postgresql.org> (raw)
Good morning List
In relation to the process of tuning the engine PostgreSQL database, especially
7.3.7 version that is being used currently, agreaceria me clarify a procedure
If I have a server with 2 GB of RAM, it is said that the shared memory segment for
the engine of the database on a dedicated server should be between 25% and maximum 33% of the RAM.
I'm doing the calculation would be the next agradeze I confirm if I am
correct
1 MB = 1,048,576
* 2 = 2097152 1048576
25% would be 2097152 * 25 / 100 = 524288
Then the shared_buffers should be 524288 / 8 = 65536 for 25% of 2 GB
or should be 524 288?
Sincerely.
Juan Pablo Sandoval Rivera
Tecnologo Prof. en Ing. de Sistemas
Linux User : 322765
msn : juan_pablos@hotmail.com
yahoo : juan_pablos@rocketmail.com (juan_pablos.rm)
UIN : 276125187 (ICQ)
Jabber : juan_pablos@www.jabberES.org
Skype : juan.pablo.sandoval.rivera
APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: juapabsan@tutopia.com
Subject: Re: Confirm calculus
In-Reply-To: <20100616191249.D1A2F633B17@mail.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox