Re: Possible to trigger autovacuum?

2024-02-20 Thread Alvaro Herrera
On 2024-Feb-19, 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 period

Re: Possible to trigger autovacuum?

2024-02-19 Thread Michael Paquier
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() metho

Possible to trigger autovacuum?

2024-02-19 Thread Chris Cleveland
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 back