bug: deadlock when dropping the extension

[kemingy]

Client error:

psycopg.errors.DeadlockDetected: deadlock detected
DETAIL:  Process 793896 waits for AccessExclusiveLock on relation 2409596 of database 103663; blocked by process 793520.
Process 793520 waits for AccessShareLock on relation 2409581 of database 103663; blocked by process 793896.
HINT:  See server log for query details.

Server log:

2024-12-24 16:56:19.399 +08 [757787] LOG:  checkpoint starting: time
2024-12-24 16:59:04.464 +08 [757787] LOG:  checkpoint complete: wrote 3671 buffers (22.4%); 0 WAL file(s) added, 1 removed, 31 recycled; write=164.140 s, sync=0.344 s, total=165.065 s; sync files=31, longest=0.122 s, average=0.012 s; distance=538485 kB, estimate=540639 kB; lsn=8/27385FB0, redo lsn=8/7E1A758
2024-12-24 16:59:04.464 +08 [757787] LOG:  checkpoint starting: wal
2024-12-24 16:59:10.969 +08 [790919] LOG:  skipping vacuum of "corpus" --- lock not available
2024-12-24 17:00:10.121 +08 [792142] LOG:  skipping vacuum of "corpus" --- lock not available
2024-12-24 17:01:23.529 +08 [793520] ERROR:  canceling autovacuum task
2024-12-24 17:01:23.529 +08 [793520] CONTEXT:  while scanning block 49570 of relation "public.corpus"
	automatic vacuum of table "vchord_bm25.public.corpus"
2024-12-24 17:01:24.533 +08 [793896] ERROR:  deadlock detected
2024-12-24 17:01:24.533 +08 [793896] DETAIL:  Process 793896 waits for AccessExclusiveLock on relation 2409596 of database 103663; blocked by process 793520.
	Process 793520 waits for AccessShareLock on relation 2409581 of database 103663; blocked by process 793896.
	Process 793896: DROP EXTENSION IF EXISTS vchord_bm25 cascade;
	Process 793520: autovacuum: ANALYZE public.queries
2024-12-24 17:01:24.533 +08 [793896] HINT:  See server log for query details.
2024-12-24 17:01:24.533 +08 [793896] STATEMENT:  DROP EXTENSION IF EXISTS vchord_bm25 cascade;
2