6 ms·
The landing page says "With Azure Database for PostgreSQL, you can scale the performance of your database with no application downtime". I don't see an option t
by ankushio 9y ago
The landing page says "With Azure Database for PostgreSQL, you can scale the performance of your database with no application downtime". I don't see an option to scale the Postgres database in my Azure Portal.
Is this feature not available yet?
- kamathsun 9y agoYou can scale by clicking on the Pricing tier. However note that scaling operations currently only support within a service tier. i.e, scaling up/down within Basic and scaling up/down within standard. Ability to scale across service tiers will come soon. /works at Microsoft and the managed PostgreSQL service /
- philliphaydon 9y agoAny idea if plv8 extension will be added soon?
- kamathsun 9y agoPlease provide feedback here - https://feedback.azure.com/forums/597976-azure-database-for-postgresql https://feedback.azure.com/forums/597976-azure-database-for-...
- deleted 9y ago[deleted]
- ankushio 9y agoI tried out this feature in the Basic tier, but my I see downtime during the scaling up of the instance. I opened a psql console and ran "BEGIN; SELECT CURRENT_TIMESTAMP; SELECT pg_sleep(200); SELECT CURRENT_TIMESTAMP; COMMIT;" I see the error "server closed the connection unexpectedly"
- kamathsun 9y agoThe application should have logic to re-try connections. When you scale, there is a brief moment ~30-45seconds when the app wont be able to connect to the database and then resumes if you re-try connection. /I work at Microsoft on the managed PostgreSQL service/
- martinknafve 9y agoHow do you accomplish no application downtime if for 45 seconds you can't connect to the database? In background processes you might get away with retrying connections for a minute but most users will probably consider your site broken if page load time is 45 seconds.
- GordonS 9y agoThat's a rather... 'liberal' use of 'no application downtime'.