Page History
...
As best practice, it is recommended to monitor these metrics in weekly intervals.
FAQ
...
| Table of Contents | ||
|---|---|---|
|
Q1: What should I do when there are many frequent imports
...
?
In case imports in your BellaDati instance are scheduled in frequent time intervals, following database script should be executed (execute this script in PostgreSQL):
...
vacuum analyze bi.import_table;Q2: There are too many
...
sorted tables in BellaDati
...
and the sorting is slow.
In case there are too many member tables (sorting), following database script should be executed multiple times (execute this script in PostgresSQL):
...
SELECT drop_tables('public', 'members_');COMMIT;Q3: BellaDati is not able to connect to the database, what should I do?
- First of all, it's necessary to check the database is running and accepting the incoming connections.
- If database is up and running, it is necessary to do further investigation:
- check the active queries - it is possible to do so from Administration console on the System summary page (database activity dump)
- if there are too many queries, it is necessary to raise up the max_connections parameter in the database configuration and the pool_size in the application server configuration
Overview
Content Tools