documentation question regarding REFRESH MATERIALIZED VIEW CONCURRENTLY

2025-02-22 Thread Tobias McNulty
Hello, The documentation [1] for REFRESH MATERIALIZED VIEW states that the "CONCURRENTLY" parameter: > Refresh[es] the materialized view without locking out concurrent selects on > the materialized > view. Without this option a refresh which affects a lot of rows will tend to > use fewer > reso

Re: Azure Database for PostgreSQL flexible server vs other Azure offerings

2025-02-22 Thread Alicja Kucharczyk
Hi Alex, as Christoph already said go with Flexible Server, Single Server was deprecated some time ago. you don't need to worry about availability zones, AI or replication if you don't want to use it. Just create a single instance in the region of choice (availability zone will be automatically as

Re: Azure Database for PostgreSQL flexible server vs other Azure offerings

2025-02-22 Thread Christoph Moench-Tegeder
## Alexander Farber (alexander.far...@gmail.com): > - https://azure.microsoft.com/en-us/products/postgresql "Azure Database for > PostgreSQL" - this one scares me be talking about AI that we do not need. > Also it looks more like some abstract product or is it a real setup? That's the top level o

Azure Database for PostgreSQL flexible server vs other Azure offerings

2025-02-22 Thread Alexander Farber
Good evening, I am trying to convince my team (a small team at a big company) to move from Azure Redis E10 to PostgreSQL, because I am tired of seeing how we (poorly) try to re-invent an SQL database using Redis. My problem is that the team does not want and I am the only one liking SQL databases