...
Code Block | ||||
---|---|---|---|---|
| ||||
\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 | ||||
---|---|---|---|---|
| ||||
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: