On 09/23/2011 02:33 PM, Neil Tiffin wrote: > I have shared_buffers in the config file set for 32 MB and pgAdmin > reports a value of 32 MB, but pgAdmin also says the current value is > 4096. Can anyone point me to any docs about why the current value > may be different than the config value? Temp_buffers are the same > way, config file 8MB, but current value in pgAdmin is 1024?
Internally shared_buffers is tracked as number of 8K pages. postgres=# show shared_buffers; shared_buffers ---------------- 32MB (1 row) postgres=# select setting from pg_settings where name='shared_buffers'; setting --------- 4096 (1 row) postgres=# select 4096 * 8 / 1024 as MB; mb ---- 32 (1 row) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
