Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Configuration Management System (CMS)2018.05

Use > Database > Deploying the PostgreSQL Server Database > PostgreSQL Server Configuration > PostgreSQL Parameter Settings

PostgreSQL Parameter Settings

The following table describes the recommended (non-default) values for a number of PostgreSQL database initialization parameters, when working with the Universal CMDB database server:

Category	Parameter Name	Universal CMDB Deployment		Defaults and Remarks
Category	Parameter Name	Small	Large	Defaults and Remarks
Memory	shared_buffers	1024 MB	4096 MB	Default: 32M, shared resource setting
	work_mem	25 MB	50 MB	Default: 1M, setting per session
	maintenance_work_mem	256 MB	340 MB	Default: 16M, setting per session
Planner	effcetive_cache_size	4096 MB	8192 MB	Default: 128M, setting per session and based on total available RAM
Checkpoint (WAL)	checkpoint_segments	32	64	Default: 3 - maximum distance in log segments between WAL checkpoints
	checkpoint_timeout	15 minutes	20 minutes	Default: 300 sec - maximum time between WAL checkpoints
	checkpoint_completion_target	0.9	0.9	Default: 0.5 - target of checkpoint completion, as a fraction of total time between checkpoints
Autovacuum	autovacuum_vacuum_threshold	5000	5000	Default: 50 - minimum number of tuple updates or deletes prior to vacuum
	autovacuum_analyze_threshold	5000	5000	Default: 50 - minimum number of tuple changes prior to analyze
	autovacuum_analyze_scale_factor	0.1	0.2	Default: 0.1 (10% of table size) – estimated percent of tuple changes prior to analyze
Logging	log_min_messages	info	info	Default: warning
	log_min_duration_statement	1500	3000	0 prints all queries; 1 turns the feature off.
	log_checkpoints	on	on	Default: off - logs each checkpoint
	log_statement	ddl	ddl	Default: none - sets the type of statements logged
	log_autovacuum_min_duration	0	0	Default: 1 - turns autovacuum logging off; 0 prints all actions

Send Help Center feedback