-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Vivek Khera
Sent: Viernes, 10 de Octubre de 2003 03:14 p.m.
To: Josh Berkus
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] go for a script! / ex: PostgreSQL vs. MySQL
>>>>> "JB" == Josh Berkus <[EMAIL PROTECTED]> writes:
JB> Vivek,
NB> shared_buffers = 1/16th of total memory
NB> effective_cache_size = 80% of the supposed kernel cache.
>>
>> Please take into account the blocksize compiled into PG, too...
JB> We can;t change the blocksize in a script that only does the .conf
JB> file. Or are you suggesting something else?
when you compute optimal shared buffers and effective cache size,
these are in terms of blocksize. so if I have 16k block size, you
can't compute based on default 8k blocksize. at worst, it would have
to be a parameter you pass to the tuning script.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
