I believe Cloudflare usage of PostgreSQL is "write heavy" and is a RDBMS that scaled out very well for them.
They are using CitusDB but it's still RDBMS and support most PostgreSQL SQL query without the need to rewrite your query or change your schema.