About "Cost-based Vacuum Delay"

From: "Ilyeop Yi" <ilyeop(dot)yi(at)samsung(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <ilyeop(dot)yi(at)samsung(dot)com>
Subject: About "Cost-based Vacuum Delay"
Date: 2018-06-14 23:29:28
Message-ID: 20180614232929epcas1p1c0a03f435b0504f543933d3680c048e2~4KqbEAa9H3081430814epcas1p1i@epcas1p1.samsung.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Guys,

I have some questions about "cost-based vacuum delay".

Q1. How can I know/check if the autovacuum is actually paused periodically
according to autovacuum_vacuum_cost_limit and autovacuum_vacuum_cost_delay?

I cannot find such an information from log files.

Q2. Is there any way to manually pause a running vacuum process?

If so, is there also any way to manually resume the paused vacuum process?

Best,
Ilyeop Yi.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Lagerman 2018-06-14 23:32:45 Re: Impact of multixact "members" limit exceeded
Previous Message Alvaro Herrera 2018-06-14 23:15:42 Re: Impact of multixact "members" limit exceeded