Re: Track the amount of time waiting due to cost_delay

Bertrand Drouvot <bertranddrouvot.pg@gmail.com>

From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>

To: Nathan Bossart <nathandbossart@gmail.com>

Cc: Dilip Kumar <dilipbalaut@gmail.com>, Masahiro Ikeda <ikedamsh@oss.nttdata.com>, "Imseih (AWS), Sami" <simseih@amazon.com>, Masahiko Sawada <sawada.mshk@gmail.com>, pgsql-hackers@lists.postgresql.org, Robert Haas <robertmhaas@gmail.com>

Date: 2024-12-12T04:36:21Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.
- 7720082ae532 18.0 landed
Add cost-based vacuum delay time to progress views.
- bb8dff9995f2 18.0 landed
Add is_analyze parameter to vacuum_delay_point().
- e5b0b0ce1509 18.0 landed
Refresh cost-based delay params more frequently in autovacuum
- 7d71d3dd080b 16.0 cited

Attachments

v11-0001-Report-the-total-amount-of-time-that-vacuum-has-.patch (text/x-diff)

Hi,

On Wed, Dec 11, 2024 at 10:40:04AM -0600, Nathan Bossart wrote:
> That's roughly what I had in mind.

Thanks for confirming, done that way in v11 attached.

> I'd vote for leaving that out, if for no other reason than it can be
> deduced from the rest of the description.

Yeah, fair enough.

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com