Hi there - I'm new to Supabase. Main question: does a Supabase Postgres instance offer 100% full Postgres capabilities (Materialized Views etc.)? We make use of Materialized View, Functions and Triggers extensively and I wonder if we can migrate over our PG 12 instance with a pg_dump/pg_restore

Yes you can do all you would do on your own Postgres instance, you can even install extensions too

Thanks! How does Supabase PG compare in terms of CPUs/RAM?

I can't say to be honest, but there are a number of sites using it in production so I would assume its managing well.

Cool thanks!