Class PostgresVacuumSettingDAO

  • All Implemented Interfaces:
    IDatabaseStatement

    public class PostgresVacuumSettingDAO
    extends Object
    implements IDatabaseStatement
    Per the Performance Guide, this DAO implements VACUUM setting changes. https://ibm.github.io/FHIR/guides/FHIRPerformanceGuide/#412-tuning-auto-vacuum Lower the trigger threshold for starting work alter table fhirdata.logical_resources SET (autovacuum_vacuum_scale_factor = 0.01, autovacuum_vacuum_threshold=1000); Increase the amount of work vacuuming completes before taking a breather (default is typically 200) alter table fhirdata.logical_resources SET (autovacuum_vacuum_cost_limit=2000);
    • Constructor Detail

      • PostgresVacuumSettingDAO

        public PostgresVacuumSettingDAO​(String schema,
                                        String tableName,
                                        int vacuumCostLimit,
                                        Double vacuumScaleFactor,
                                        int vacuumThreshold)
        sets up the vacuum setting for Postgres
        Parameters:
        schema -
        tableName -
        vacuumCostLimit -
        vacuumScaleFactor -
        vacuumThreshold -