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

  Bruce Momjian                        |
  [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

Reply via email to