pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedautovacuum_vacuum_cost_limit
5+ messages / 3 participants
[nested] [flat]
* autovacuum_vacuum_cost_limit
@ 2021-04-09 20:19 Henry Francisco Garcia Cortez <garcortez@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Henry Francisco Garcia Cortez @ 2021-04-09 20:19 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org; +Cc: david.g.johnston@gmail.com
Hi community I have a question about autovacuum_vacuum_cost_limit I want
to increase this parameter I have read on internet that value It could have
as maximum 10,000 but I want to know, what will it be the troubles if I did
that change
--
Ing. Henry G. Cortez
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: autovacuum_vacuum_cost_limit
@ 2021-04-10 01:43 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Henry Francisco Garcia Cortez <garcortez@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2021-04-10 01:43 UTC (permalink / raw)
To: Henry Francisco Garcia Cortez <garcortez@gmail.com>; pgsql-admin@lists.postgresql.org; +Cc: david.g.johnston@gmail.com
On Fri, 2021-04-09 at 14:19 -0600, Henry Francisco Garcia Cortez wrote:
> Hi community I have a question about autovacuum_vacuum_cost_limit
> I want to increase this parameter I have read on internet that value
> It could have as maximum 10,000 but I want to know, what will it be the troubles if I did that change
That will keep PostgreSQL from functioning properly.
I would never increase the setting beyond the 20ms that were the default before v12.
If the three autovacuum workers allowed by autovacuum_max_workers are already enough
to strain your I/O resources, consider getting more powerful storage.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: autovacuum_vacuum_cost_limit
@ 2021-04-10 01:50 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 5+ messages in thread
From: Alvaro Herrera @ 2021-04-10 01:50 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Henry Francisco Garcia Cortez <garcortez@gmail.com>; pgsql-admin@lists.postgresql.org; david.g.johnston@gmail.com
On 2021-Apr-10, Laurenz Albe wrote:
> On Fri, 2021-04-09 at 14:19 -0600, Henry Francisco Garcia Cortez wrote:
> > Hi community I have a question about autovacuum_vacuum_cost_limit
> > I want to increase this parameter I have read on internet that value
> > It could have as maximum 10,000 but I want to know, what will it be the troubles if I did that change
>
> That will keep PostgreSQL from functioning properly.
>
> I would never increase the setting beyond the 20ms that were the
> default before v12.
I think you're confusing it with autovacuum_vacuum_cost_delay. He is
asking about the cost_limit. Increasing that setting will mean that the
20ms sleeps will occur much less frequently.
--
Álvaro Herrera Valdivia, Chile
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: autovacuum_vacuum_cost_limit
@ 2021-04-10 09:28 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2021-04-10 09:28 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: Henry Francisco Garcia Cortez <garcortez@gmail.com>; pgsql-admin@lists.postgresql.org; david.g.johnston@gmail.com
On Fri, 2021-04-09 at 21:50 -0400, Alvaro Herrera wrote:
> On 2021-Apr-10, Laurenz Albe wrote:
> > On Fri, 2021-04-09 at 14:19 -0600, Henry Francisco Garcia Cortez wrote:
> > > Hi community I have a question about autovacuum_vacuum_cost_limit
> > > I want to increase this parameter I have read on internet that value
> > > It could have as maximum 10,000 but I want to know, what will it be the troubles if I did that change
> >
> > That will keep PostgreSQL from functioning properly.
> > I would never increase the setting beyond the 20ms that were the
> > default before v12.
>
> I think you're confusing it with autovacuum_vacuum_cost_delay. He is
> asking about the cost_limit. Increasing that setting will mean that the
> 20ms sleeps will occur much less frequently.
Yes, indeed. Sorry.
Increasing "autovacuum_vacuum_cost_limit" will make autovacuum run faster.
There is no problem with increasing it as much as you want.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: autovacuum_vacuum_cost_limit
@ 2021-04-12 14:51 Henry Francisco Garcia Cortez <garcortez@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 5+ messages in thread
From: Henry Francisco Garcia Cortez @ 2021-04-12 14:51 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>; pgsql-admin@lists.postgresql.org; david.g.johnston@gmail.com
Thank you comments
El sáb, 10 abr 2021 a las 3:28, Laurenz Albe (<laurenz.albe@cybertec.at>)
escribió:
> On Fri, 2021-04-09 at 21:50 -0400, Alvaro Herrera wrote:
> > On 2021-Apr-10, Laurenz Albe wrote:
> > > On Fri, 2021-04-09 at 14:19 -0600, Henry Francisco Garcia Cortez wrote:
> > > > Hi community I have a question about autovacuum_vacuum_cost_limit
> > > > I want to increase this parameter I have read on internet that
> value
> > > > It could have as maximum 10,000 but I want to know, what will it
> be the troubles if I did that change
> > >
> > > That will keep PostgreSQL from functioning properly.
> > > I would never increase the setting beyond the 20ms that were the
> > > default before v12.
> >
> > I think you're confusing it with autovacuum_vacuum_cost_delay. He is
> > asking about the cost_limit. Increasing that setting will mean that the
> > 20ms sleeps will occur much less frequently.
>
> Yes, indeed. Sorry.
>
> Increasing "autovacuum_vacuum_cost_limit" will make autovacuum run faster.
> There is no problem with increasing it as much as you want.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
--
Ing. Henry G. Cortez
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-04-12 14:51 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-04-09 20:19 autovacuum_vacuum_cost_limit Henry Francisco Garcia Cortez <garcortez@gmail.com>
2021-04-10 01:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-04-10 01:50 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2021-04-10 09:28 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-04-12 14:51 ` Henry Francisco Garcia Cortez <garcortez@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