Confirm calculus

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.

Responses

Browse pgsql-performance by date

  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