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
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 |