Hi All,
We have a 6TB database, and whenever we are running delete on that DB. Database performance Drastically reduces and we run into multixact errors, to overcome it we have to stop deletion process and run Manual Vaccuming.
ERROR: “multixact “members” limit exceeded”
We have to do bulk deletion of rows and we are running into errors just after 2gb of deletions.
Autovaccuming is enabled. Please suggest a way to delete Bulk rows from timescale/postgres db.
Note: CHUNK DELETION is not an option.
we are using 96cpu and 768gb of MEmory on machine.
name | autovacuum_analyze_scale_factor
setting | 0.1
name | autovacuum_analyze_threshold
setting | 50
name | autovacuum_freeze_max_age
setting | 200000000
name | autovacuum_max_workers
setting | 12
name | autovacuum_multixact_freeze_max_age
setting | 400000000
name | autovacuum_naptime
setting | 1
name | autovacuum_vacuum_cost_delay
setting | 2
name | autovacuum_vacuum_cost_limit
setting | -1
name | autovacuum_vacuum_insert_scale_factor
setting | 0.2
name | autovacuum_vacuum_insert_threshold
setting | 1000
name | autovacuum_vacuum_scale_factor
setting | 0.2
name | autovacuum_vacuum_threshold
setting | 50
name | autovacuum_work_mem
setting | -1