Microsoft
MicrosoftSean,
Thank you for the feedback! Let me comment on few things.
Upgrade to Postgres 14 not showing as an option for Postgres 11: Correct, that is the case at this moment and it is one of the steps in enabling Postgres 14 in Azure portal. Internally we started with Postgres 13 to Postgres 14 upgrade scenario and then extended it to all versions by the time we made Postgres 14 available publicly. Portal update is catching up and should allow direct upgrade from any Postgres version (11, 12, or 13) to Postgres 14 in a few days.
Things like materialized views have special consideration when you use Citus due to the nature of distributed database. For instance, as you probably know you can use materialized views in Hyperscale (Citus) but only on coordinator node. Our recommendation for those who would like to use materialized views functionality is to use rollup tables and run INSERT INTO SELECT commands to populate the rollup tables. There are some functionality/performance benefits with rollup tables as explained in this blog post.
Some other things that you mentioned seem to be unfortunate issues on your server group. I am really sorry you had this experience with our product. I understand it is not going to make your past experience better and erase these issues but I would like to assure you that we are using it as an opportunity to analyze how we can prevent similar issues going forward.
Kind regards,
Nik, Hyperscale (Citus) team