Friday, October 19, 2012

PostgreSQL: check the core settings of server

SELECT name, context, unit, setting, short_desc

FROM pg_settings

WHERE name in ('listen_addresses' ,'max_connections' ,'shared_buffers' ,'effective_cache_size' , 'work_mem' , 'maintenance_work_mem')

ORDER BY context,name;

image

If context is set to postmaster, it means changing this parameter requires a restart of the postgresql service. If context is set to user, changes require at least a reload. Furthermore, these settings can be            overridden at the database, user, session, or function levels.

unit tells you the unit of measurement that the setting is reported in. This is very important for memory settings since, as you can see, some are reported in 8 kB and some in kB

No comments:

Post a Comment