>>>>> "BM" == Bruce Momjian <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to