Class PostgresVacuumSettingDAO

  • All Implemented Interfaces:
    IDatabaseStatement

    public class PostgresVacuumSettingDAO
    extends java.lang.Object
    implements IDatabaseStatement
    Per the Performance Guide, this DAO implements VACUUM setting changes. https://linuxforhealth.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 Summary

      Constructors 
      Constructor Description
      PostgresVacuumSettingDAO​(java.lang.String schema, java.lang.String tableName, int vacuumCostLimit, java.lang.Double vacuumScaleFactor, int vacuumThreshold)
      sets up the vacuum setting for Postgres
    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      void run​(IDatabaseTranslator translator, java.sql.Connection c)
      Execute the statement using the connection.
      • Methods inherited from class java.lang.Object

        clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • PostgresVacuumSettingDAO

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