Hacker News Reader

Comment by ankushio | Hacker News Reader

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?

View on HN

You 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 /

Any idea if plv8 extension will be added soon?

Please provide feedback here - https://feedback.azure.com/forums/597976-azure-database-for-...

I 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"

The 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/

How 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.

That's a rather... 'liberal' use of 'no application downtime'.

Reply on news.ycombinator.com