Re: Various performance questions

Dror Matalon <dror@zapatec.com>

From: Dror Matalon <dror@zapatec.com>
To: pgsql-performance@postgresql.org
Date: 2003-10-27T17:23:10Z
Lists: pgsql-performance
On Mon, Oct 27, 2003 at 11:12:37AM -0500, Vivek Khera wrote:
> >>>>> "DM" == Dror Matalon <dror@zapatec.com> writes:
> 
> DM> effective_cache_size = 25520  -- freebsd forumla: vfs.hibufspace / 8192
> 
> DM> 1. While it seems to work correctly, I'm unclear on why this number is
> DM> correct.  25520*8 = 204160 or 200 Megs. On a machine with 2 Gigs it
> DM> seems like the number should be more like 1 - 1.5 Gigs.
> 
> Nope, that's correct...

I know it's correct. I was asking why it's correct.

> 
> 
> -- 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera Communications, Inc.
> Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

-- 
Dror Matalon
Zapatec Inc 
1700 MLK Way
Berkeley, CA 94709
http://www.zapatec.com