Shared Buffers

From: Dennis <dennis(at)zserve(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Shared Buffers
Date: 2001-06-21 20:17:55
Message-ID: 9gtkpj$les$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


When starting postmaster, you can add the -B option to indicate the amount
of shared buffers you want postgres to use. You can also specify the value
in postgresql.conf.

I read in the documentation that 1 shared buffer is 8192 bytes. Somone
posted a while back that it was most optimal to let postgres have about 1/4
of the memory on a dedicated machine.

So, I have 512 megs on a dedicated machine. I divide that by 4 and then
times the number of bytes in a meg and divide by 8192 and I get 16384.
By the 1/4 standard, it seems I should set "-B 16384" at postgres startup.

Postgres defaults to 64 Shared Buffers. That is a big difference from
16384. Is there any reason to my logic here or am I way off?

Can anyone supply some more information or maybe suggest the most
optimum way to use Shared Buffers. Is the 1/4 standard good or should
I use even more.. or much less?

Thanks in advance.
Dennis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stock, Stuart H. 2001-06-21 20:30:31 RE: Error: cannot write block XX of XXXXX/XXXXX blind: resource tempo rarily unavailable
Previous Message Tom Lane 2001-06-21 20:02:11 Re: [GENERAL] Call for alpha testing: planner statistics revisions