Holy crap, OrioleDB, a fork of Postgres, got rid of vacuuming, which was definitely my #1 complaint

https://www.orioledata.com/blog/no-more-vacuum-in-postgresql/

PostgreSQL: No More VACUUM, No More Bloat

This is meta description

@bascule
Postgres isn't removing vacuum anytime soon
Quite sure of that.

For posterity here's the current psql docs:
https://www.postgresql.org/docs/16/sql-vacuum.html

Postgres16 was released last month

VACUUM

VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …

PostgreSQL Documentation