Vivek Khera wrote: > >>>>> "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.
Also, to check, you can use ipcs to see the shared memory sizes allocated. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly