Database Reference
In-Depth Information
setting | 1024
unit | kB
category | Resource Usage / Memory
short_desc | Sets the maximum memory to be used for query workspaces.
extra_desc | This much memory can be used by each internal sort
operation and hash table before switching to temporary disk files.
context | user
vartype | integer
source | default
min_val | 64
max_val | 2147483647
enumvals |
boot_val | 1024
reset_val | 1024
sourcefile |
sourceline |
So, you can use the
SHOW
command to retrieve the value for a setting, or you can access
the full detail via the catalog table.
How it works...
Each parameter setting is cached within each session so that we have fast access
to the parameter settings. That allows us to access the parameter settings with ease.
Remember that the values displayed are not necessarily settings for the server as a whole;
many of those parameters will be specific to the current session. That's different in many
other databases and is also very useful.
Which parameters are at non-default
settings?
Often, we need to check which parameters have been changed already or whether
our changes have correctly taken effect.
How to do it...
postgres=# SELECT name, source, setting
FROM pg_settings
WHERE source != 'default
AND source != 'override'
ORDER by 2, 1;
…..........name …..........|........source.......|..setting
---------------------------+---------------------+----------
