Postgresql installation and setup

1. Install Postgresql (to for example, on CentOS 7 for example) with command

Code Block

language	bash
theme	RDark

yum install postgresql-server

...

Code Block

language	bash
theme	RDark

\q
exit

DB queries optimizing

In builds before 1.163, to speed up Postgresql and to decrease CPU load, the following indexed should be created after successfull launch of WCS OAM:

Code Block

language	sql
theme	RDark

CREATE INDEX ON stream(name, media_id, node_id);
CREATE INDEX ON stream(node_id, name, status);
CREATE INDEX ON stream(publisher_id);

Data structure of stream table in wcsoam database should look as follows:

Image Added