Useful SQL commands PDF Print E-mail
Written by Carl Friis-Hansen   
Wednesday, 06 May 2009 12:58

Show where the files are stored:

SELECT name, setting
FROM pg_settings
WHERE category = 'File Locations';

Listing of memory setting:

SELECT name, setting, unit, category
FROM pg_settings
WHERE name like '%mem%' or name LIKE 'constraint%' or name like '%buffer%'
ORDER BY name;

Alternatively in this way:

SELECT name, setting, current_setting(name),unit, category 
FROM pg_settings
WHERE name like '%mem%' or name LIKE 'constraint%' or name like '%buffer%' or name like 'effective%'
ORDER BY name;


Categories and setting:

SELECT DISTINCT category
FROM pg_settings
ORDER BY category;

Last Updated on Wednesday, 06 May 2009 13:08
 

Add comment

To be able to vote and have easier access to write comments, etc., go to Login and register yourself.
Your user name and email will never leave this website.


Security code
Refresh