Cost estimation for Azure PostgreSQL Flexible Server with PGVector

Question

What is the estimated cost for using Azure PostgreSQL Flexible Server with PGVector enabled, targeting a throughput of 50 Queries per second? Cost should also include serving 1M dataset inclusive of data/index storage, backup, compute resources. Any references or details regarding this would be helpful.

Answer 1

Hi Sai,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As we understand that, you are inquiring about estimate the cost of using Azure PostgreSQL Flexible Server with PGVector enabled, targeting a throughput of 50 Queries per second and serving a 1M dataset inclusive of data/index storage, backup, and compute resources.

We can break down the costs into several components:

Regarding to the pricing overview: Azure Database for PostgreSQL is a fully-managed database as a service with built-in capabilities such as high availability and intelligence. Pricing is based on the compute, memory, and storage you provision. You can use the Azure pricing calculator to customize pricing options to your needs. Please refer to this document. https://azure.microsoft.com/en-us/pricing/details/postgresql/flexible-server/

Compute Options: You can create an Azure Database for PostgreSQL flexible server instance in one of three pricing tiers: Burstable, General Purpose, and Memory Optimized. The pricing tier is calculated based on the compute, memory, and storage you provision.https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-compute

Cost Optimization: By creating a test server in a region with lower cost of computing resources, you can reduce the cost of running your test server and minimize the cost of running Azure Database for PostgreSQL Flexible Server. https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-cost-optimization

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.