Package org.linuxforhealth.fhir.database.utils.postgres

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

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

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 interface IDatabaseStatement

Parameters:

translator - to translate any exceptions