Am 17.08.23 um 21:06 schrieb Rajesh Kumar:
These are parameters have reg autovacuum. Autovacuum is not running properly. How to resolve this?autovacuum=on log_autovacuum_min_duration=0 autovacuum_max_workers=3 autovacuum_naptime=1min autovacuum_vacuum_threshold=50 autovacuum_analyze_threshold=50 autovacuum_vacuum_cost_limit=-1 autovacuum_vacuum_cost_delay=2ms autovacuum_freeze_max_age=200000000 autovacuum_vacuum_scale_factor=0.2 autovacuum_analyze_scale_factor=0.1
Every setting has to be on its own line.To resolve problems, comment out all settings in the same way as it was after install.
Then try them step by step. -- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature