Re: Various performance questions - Mailing list pgsql-performance

From Dror Matalon
Subject Re: Various performance questions
Date
Msg-id 20031027172310.GI2979@rlx11.zapatec.com
Whole thread Raw
In response to Re: Various performance questions  (Vivek Khera <khera@kcilink.com>)
List 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use of multipart index with "IN"
Next
From: Dror Matalon
Date:
Subject: Re: Various performance questions