Обсуждение: 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