Re: FreeBSD page size - Mailing list pgsql-performance

From Vivek Khera
Subject Re: FreeBSD page size
Date
Msg-id x7znhkgtna.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to Re: FreeBSD page size  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: FreeBSD page size  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: FreeBSD page size  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-performance
>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:


BM> The 32k number is from Tatsuo testing a few years ago.

Can you verify for me that these parameters in postgresql.conf are
based on the BLCKSZ (ie one buffer is the size of the BLCKSIZ macro):

shared_buffers
effective_cache_size

Logically it makes sense, but I want to be sure I'm adjusting my
postgresql.conf parameters accordingly when I try different block
sizes.

Thanks.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FreeBSD page size
Next
From: "scott.marlowe"
Date:
Subject: Re: FreeBSD page size (was Re: The results of my