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.

Uh, yes, I think they have to be the same because they are pages in the
shared buffer cache, not disk blocks.

  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 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to