Storage Parameters

Top Previous Next

You can set and specify storage parameters for tables. The storage parameters currently available for tables are listed below. For each parameter, unless noted, there is an additional parameter with the same name prefixed with toast., which can be used to control the behavior of the table's secondary TOAST table, if any. Note that the TOAST table inherits the autovacuum_* values from its parent table, if there are no toast.autovacuum_* settings set. For details see the PostgreSQL manual.



The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default. When a smaller fillfactor is specified, INSERT operations pack table pages only to the indicated percentage; the remaining space on each page is reserved for updating rows on that page. This gives UPDATE a chance to place the updated copy of a row on the same page as the original, which is more efficient than placing it on a different page. For a table whose entries are never updated, complete packing is the best choice, but in heavily updated tables smaller fillfactors are appropriate. This parameter cannot be set for TOAST tables.

autovacuum_enabled, toast.autovacuum_enabled

Enables or disables the autovacuum daemon on a particular table.

autovacuum_vacuum_threshold, toast.autovacuum_vacuum_threshold

Minimum number of updated or deleted tuples before initiate a VACUUM operation on a particular table.

autovacuum_vacuum_scale_factor, toast.autovacuum_vacuum_scale_factor

Multiplier for reltuples to add to autovacuum_vacuum_threshold.


Minimum number of inserted, updated, or deleted tuples before initiate an ANALYZE operation on a particular table.


Multiplier for reltuples to add to autovacuum_analyze_threshold.

autovacuum_vacuum_cost_delay, toast.autovacuum_vacuum_cost_delay

See PostgreSQL manual.

autovacuum_vacuum_cost_limit, toast.autovacuum_vacuum_cost_limit

See PostgreSQL manual.

autovacuum_freeze_min_age, toast.autovacuum_freeze_min_age

See PostgreSQL manual.

autovacuum_freeze_max_age, toast.autovacuum_freeze_max_age

See PostgreSQL manual.

autovacuum_freeze_table_age, toast.autovacuum_freeze_table_age

See PostgreSQL manual.

See also:
Diagram Objects: Table Editor