Skip to content

Instantly share code, notes, and snippets.

View vcabbage's full-sized avatar

Kale Blankenship vcabbage

View GitHub Profile
@ralph-tice
ralph-tice / gist:c2943aa672aaa65ecb59
Last active May 16, 2017 02:30
PostgreSQL settings to aggressively vacuum, this config was used for an 18000 TPS steadystate workload on i2.xlarge
#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#------------------------------------------------------------------------------
#autovacuum = on # Enable autovacuum subprocess? 'on'
# requires track_counts to also be on.
log_autovacuum_min_duration = 0 # -1 disables, 0 logs all actions and
# their durations, > 0 logs only
# actions running at least this number
# of milliseconds.