On Mon, Feb 19, 2024 at 03:15:29PM -0600, Chris Cleveland wrote: > Is it possible to launch an autovacuum from within an extension? > > I'm developing an index access method. After the index gets built it needs > some cleanup and optimization. I'd prefer to do this in the > amvacuumcleanup() method so it can happen periodically and asynchronously. > > I could fire up a background worker to do the job, but it would be a lot > simpler to call please_launch_autovacuum_right_now();
The autovacuum launcher can be stopped in its nap with signals, like a SIGHUP. So you could rely on that to force a job to happen on a given database based on the timing you're aiming for. -- Michael
signature.asc
Description: PGP signature