Products | Versions |
---|---|
TIBCO Data Virtualization | 7.0.x |
Business Directory Security_privileges table is bloating( in GB)
alter table bdrepo.security_privileges set(autovacuum_enabled=true); alter table bdrepo.security_privileges set(fillfactor=100); alter table bdrepo.security_privileges set(autovacuum_analyze_scale_factor=0.2); alter table bdrepo.security_privileges set(autovacuum_vacuum_cost_limit = 1000); alter table bdrepo.security_privileges set(autovacuum_vacuum_scale_factor = 0); alter table bdrepo.security_privileges SET (autovacuum_vacuum_threshold = 10000); alter table bdrepo.security_privileges set(autovacuum_vacuum_cost_delay = 10);
select relname, reloptions, pg_namespace.nspname from pg_class join pg_namespace on pg_namespace.oid = pg_class.relnamespace where relname like 'security_privileges';
SELECT * FROM pg_stat_activity WHERE state = 'idle in transaction';If they haven't upgraded to 7.0.6.00.02 yet, setting below mentioned pool size configurations in "/apps/server/server_defs-<most recent version>.xml" to 0 may help. However, there are some importat fixes that went into Pool manager implementation that is only available in 7.0.6 patch 2.
Pool Minimum Size (Current) Pool Minimum Size (On Server Restart) Monitor daemon Pool Minimum Size (Current) Monitor daemon Pool Minimum Size (Current)