Results for topic "performance":
Check for OutOfMemory error - SysAdmin
… How to troubleshoot server performance problems that are caused by memory leaks. Introduction If the execution time of your server application significantly inc
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-server-and-services/check-for-memory-leaks
cdb perfomance optimization_SysAdmin
… Improve the performance of the cdb by adjusting compression level and index configuration. Compression level …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/censhare-server/embedded-censhare-database-cdb/cdb-performance-optimization
Improve performance for remote asset events_sysadmin
… With large numbers of remote asset events and slow network connections, the performance of the master server can be impacted. If processing the remote asset eve …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-server-and-services/improve-performance-for-remote-asset-events
RAM allocation for censhare Server- SysAdmin
… Monitor the RAM usage of the allocated memory. Configuration practices Diagrams-JVM-memory.jpeg Considerations when increasing the allocated RAM for the censhar
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-server-and-services/ram-allocation-for-censhare-server
Performance analysis of censhare Server_sysadmin
… How to perform a censhare Server basic performance analysis (ca. 15-60 min.) for all logged-in users up to the case that no new client login is possible. Import …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-server-and-services/performance-analysis-of-censhare-server
Analyse database connections_sysadmin
… Learn about the best practices to analyze database connections. Configuration practices databaseconnections.jpeg Maximum open database connections to configure
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-database-performamce/analyse-database-connections
Vacuum process for PostgreSQL databases_sysadmin
… 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.
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-database-performamce/vacuum-process-for-postgresql-databases
PostgreSQL database performance check_sysadmin
… Learn about the performance of a PostgreSQL database. Configure PostgreSQL for pretty good performance Every PostgreSQL database has a default configuration but<< EOF \pset format wrapped; \pset linestyle unicod; \pset columns 180; Select 'select pg_terminate_backend('||pid||') from pg_stat_activity;' kill_query,usename,state,client_addr,query,query_start From pg_stat_activity where datname='corpus' AND pid <>< current_timestamp - INTERVAL '30' MINUTE; EOF After running the above code, it provides "proc_id's" with other information in the "kill_query" column section and terminate the idle sessions by the following command. Run from "corpus" user to connect with "corpus" database. select pg_terminate_backend(