We are running PostgreSQL 9.2 on CentOS 6 and I am seeing the settings are reported differently when I run the
show effective_cache_size; command vs
select * from pg_settings where name = 'effective_cache_size'; query. As far as I can understand these commands should be identical. For example
show effective_cache_size; effective_cache_size ---------------------- 2816MB (1 row)
select name,setting from pg_settings where name = 'effective_cache_size'; name | effective_cache_size setting | 360448
I am trying to figure out the value used by PostgreSQL. I get the same results if I run this as a superuser. Which one do I trust?