Re: Autovacuum not working peoperly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux