Keeping your Postgres at its best
ANALYZE
and VACCUM
autovacuum_analyze_scale_factor
and autovacuum_vacuum_scale_factor
are set to a sensible value. We recommend 0.1
by default,
but it depends on the size of your tables.
events
, invoices
, charges
and fees
.
Configure custom override values for these tables.
For example, the events
table should use a value lower than 0.01
.
Because this factor is a ratio, it’s expected to lower it from time to time as your table size grows.
events
. Depending on your implementation, this table can receive big
burst of data and should be analyzed and vacuumed often.events
table after the batch is ingested: