Since Postgres 12, there's been support for “Pluggable Storage” where you could even define different storage engines for tables individually. Think of the Oriole extension which bought by Supabase in April 2024.