Re: Various performance questions

Поиск
Список
Период
Сортировка
От Dror Matalon
Тема Re: Various performance questions
Дата
Msg-id 20031027172310.GI2979@rlx11.zapatec.com
обсуждение исходный текст
Ответ на Re: Various performance questions  (Vivek Khera <khera@kcilink.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Use of multipart index with "IN"
Следующее
От: Dror Matalon
Дата:
Сообщение: Re: Various performance questions