> Also perhaps when I want to update the schema of my database and not "stop" the inflow of messages, not sure if this would be easy?

Doesn't PostgreSQL have transactional schema updates as a key feature? AIUI, you shouldn't be having any data loss as a result of such changes. It's also common to use views in order to simplify the management of such updates.