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

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: 2003-10-11 05:20:43
Message-ID: 3F87932B.4050507@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Moore-Oliva 2003-10-11 09:10:53 PQnotifies and freeing memory.
Previous Message Claudio Lapidus 2003-10-11 05:00:03 "slicing" records

Browse pgsql-performance by date

  From Date Subject
Next Message Sean Chittenden 2003-10-11 09:23:08 Re: go for a script! / ex: PostgreSQL vs. MySQL
Previous Message Ron Johnson 2003-10-11 02:01:12 Re: Index/Foreign Key Question