Re: [PERFORM] go for a script! / ex: PostgreSQL vs. MySQL

[Christopher Kings-Lynne]

NB> shared_buffers = 1/16th of total memory
NB> effective_cache_size = 80% of the supposed kernel cache.


Advertising






I think Sean(?) mentioned this one for FreeBSD (Bash code):

echo "effective_cache_size = $((`sysctl -n vfs.hibufspace` / 8192))"

I've used it for my dedicated servers.  Is this calculation correct?

Chris

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend