Обсуждение: shared_buffers setting

Hi All;

I'm unclear per the docs what the effect is of specifying a shared
buffers value without a kB or an MB at the end.
For example if I specify shared buffers as:

shared_buffers = 5000

would this equate to 5000 8K pages, or 5000K, 5000bytes?



I usually specify the buffers in MB but I want to be sure I'm tuning
an existing install properly - the previous DBA has used the
convention above.


Thanks in advance

/Kevin

kevin kempter <kevin@kevinkempterllc.com> writes:
> I'm unclear per the docs what the effect is of specifying a shared
> buffers value without a kB or an MB at the end.
> For example if I specify shared buffers as:
> shared_buffers = 5000
> would this equate to 5000 8K pages, or 5000K, 5000bytes?

Pages.  When in doubt, look at the units column of pg_settings.

            regards, tom lane

Thanks !


On Sep 15, 2008, at 7:10 PM, Tom Lane wrote:

> kevin kempter <kevin@kevinkempterllc.com> writes:
>> I'm unclear per the docs what the effect is of specifying a shared
>> buffers value without a kB or an MB at the end.
>> For example if I specify shared buffers as:
>> shared_buffers = 5000
>> would this equate to 5000 8K pages, or 5000K, 5000bytes?
>
> Pages.  When in doubt, look at the units column of pg_settings.
>
>             regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin