pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAutovacuum not working peoperly
4+ messages / 3 participants
[nested] [flat]
* Autovacuum not working peoperly
@ 2023-08-17 19:06 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Rajesh Kumar @ 2023-08-17 19:06 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Autovacuum not working peoperly
@ 2023-08-17 21:14 Ron <ronljohnsonjr@gmail.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Ron @ 2023-08-17 21:14 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 8/17/23 14:06, Rajesh Kumar wrote:
> 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
Please clarify "not working properly".
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Autovacuum not working peoperly
@ 2023-08-17 21:17 Holger Jakobs <holger@jakobs.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Holger Jakobs @ 2023-08-17 21:17 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../../588612c2-d539-e344-3115-2c5a511d8350@jakobs.com/2-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Autovacuum not working peoperly
@ 2023-08-18 12:49 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 4+ messages in thread
From: Rajesh Kumar @ 2023-08-18 12:49 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
Not working properly refers might be because updates or delete or inserts
might be more than the scheduled vacuum.
On Fri, 18 Aug, 2023, 2:47 AM Holger Jakobs, <holger@jakobs.com> wrote:
> 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
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-08-18 12:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-17 19:06 Autovacuum not working peoperly Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-17 21:14 ` Ron <ronljohnsonjr@gmail.com>
2023-08-17 21:17 ` Holger Jakobs <holger@jakobs.com>
2023-08-18 12:49 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox