Class PostgresVacuumSettingDAO
- java.lang.Object
-
- org.linuxforhealth.fhir.database.utils.postgres.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.
-
-
-
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
-
run
public void run(IDatabaseTranslator translator, java.sql.Connection c)
Description copied from interface:IDatabaseStatement
Execute the statement using the connection.- Specified by:
run
in interfaceIDatabaseStatement
- Parameters:
translator
- to translate any exceptions
-
-