PostgresQL autovacuum & ANALYZE

• tags: PostgresQL

Recently, I met a problem in PostgresQL: the index mismatched after batch rows inserted.

Run ANALYZE on the table solved this problem after batch rows inerted.

Turns out autovacuum has been disabled on the PostgresQL instance:

show autovacuum_analyze_scale_factor;
show autovacuum_analyze_threshold ;
SELECT *
FROM pg_settings
WHERE name LIKE '%autovacuum%';