Monitor database performance

Monitor the two databases - native PostgreSQL/Oracle and the embedded cdb.

PostgreSQL and Oracle

Page:

PostgreSQL database performance check — Learn about the performance of a PostgreSQL database.
Page:

Vacuum process for PostgreSQL databases — Database vacuuming is a way to increase the table and database performance of a PostgreSQL database. Learn how to use the vacuum process to clean the database.
Page:

Analyse database connections — Learn about the best practices to analyze database connections.
Page:

Oracle database performance checks — A collections of commands to check your Oracle database performance.
Page:

Oracle database performance checks (Admin Client) — The censhare Admin Client offers a built-in performance analysis tools for the connected Oracle database.

CDB

Page:

Embedded censhare database (cdb) — The cdb is the in-memory graph database of censhare and stores a real-time copy of the central metadata plus locally managed indexes for fast searching and read access without requests to the external relational database.
Page:

Rebuild cdb — How to rebuild the censhare embedded database (cdb) based on a Linux operating system.
Page:

cdb performance optimization — Improve the performance of the cdb by adjusting compression level and index configuration.
Page:

Optimize CDB - adjust feature indexes — Adjust the indexes in the censhare database (CDB). Use config.xml (AssetStore).
Page:

Optimize CDB - fast index rebuilding — The censhare embedded database (CDB) saves resources through compression and fast rebuilding of the index. In addition, find comprehensive statistics to evaluate the data structure.