From: | Juan Pablo Sandoval Rivera <juapabsan(at)tutopia(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Confirm calculus |
Date: | 2010-06-16 13:46:07 |
Message-ID: | 20100616191255.BEF916349F0@mail.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)hotmail(dot)com
yahoo : juan_pablos(at)rocketmail(dot)com (juan_pablos.rm)
UIN : 276125187 (ICQ)
Jabber : juan_pablos(at)www(dot)jabberES(dot)org
Skype : juan.pablo.sandoval.rivera
APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-06-16 14:33:02 | Re: Analysis Function |
Previous Message | Juan Pablo Sandoval Rivera | 2010-06-16 13:45:57 | Confirm calculus |