From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Neil Tiffin <neil(at)neiltiffin(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Mac OS X shared_buffers not same as postgresql.conf file |
Date: | 2011-09-24 18:31:28 |
Message-ID: | 4E7E2200.8010607@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marti Raudsepp | 2011-09-24 19:06:09 | Re: pg_dump compress |
Previous Message | Adrian Klaver | 2011-09-24 18:23:57 | Re: Documentation of what schema modifications cause what level of table locking |