Managed Database

Since we can use the standby instances as read-only we really need to be able to see the insights for the standby instances.

I'd like to see if / when my standby nodes have been used, this will help me decide if I need one, two, or maybe none at all.

Currently its only possible to upgrade a cluster. Thats great when we have alot of requests. But after the peak we would like to downgrade the cluster to same money. Currently the only option is to create a new cluster, migrate the date and delete the old one. But that is not a solution!

Please consider supporting YugabyteDB as a managed database engine. YugabyteDB is a distributed SQL database with PostgreSQL compatibility, ideal for scalable, cloud-native apps.

Add Datadog as log forwarding endpoint for managed databases. This is available for App Platform, but not for dbs. Thanks!

Please allow for disabling database access publicly. I want to connect to it using VPC. I can choose to not use the public access connection information and protect it through obscurity but it would be ideal to not have it enabled instead.

Downsizing a database is especially useful when you expect a high amount of traffic coming in and you temporarily upgrade your database. After that period you would be able to downsize your database to its needed performance tier. Also having to fork the cluster, changing all the Uri strings in your applications, adding the latest data to the database is very inconvenient and could just be solved with this feature, which I'm sure a lot of users want.

Why this is important: Our company specializes in AI applications and leverages DigitalOcean for all our AI infrastructure needs. We manage millions of vector records in our DigitalOcean Managed Database, currently utilizing the pgvector extension and Hnsw index type. However, we face significant challenges with our current setup: Our Hnsw indexes are approximately 50GB in size, consuming substantial RAM and making scalability a challenge. Index building is time-intensive, taking several days to complete, which hampers our operational efficiency. As we aim to triple our current indexing capacity to support business growth, it is crucial to adopt more cost-effective and faster technologies. pgvectorscale presents a viable solution that can help us reduce costs and enhance indexing speeds, which are essential for our continued growth and competitiveness. What is pgvectorscale: pgvectorscale is an extension that builds upon pgvector to offer higher performance in embedding search and more cost-efficient storage for AI applications, making it an ideal upgrade for our database systems. It includes key innovations such as: StreamingDiskANN : A new index type inspired by the DiskANN algorithm, which is a research output from Microsoft. Statistical Binary Quantization : Developed by researchers at Timescale, this advanced compression method improves upon traditional Binary Quantization techniques. Additional Information and Resources: Performance Metrics: According to Timescale, pgvectorscale achieves performance up to 28x faster than Pinecone, with significant cost reductions. More details can be found in their recent blog post: Timescale Blog: pgvector is now as fast as Pinecone at 75% less cost Source Code and Documentation: For technical details and implementation specifics, refer to the pgvectorscale GitHub repository: GitHub - pgvectorscale ---- We believe that integrating pgvectorscale into DigitalOcean's managed PostgreSQL offerings will not only benefit our operations but also enhance the service offering for other clients with similar needs. We request your consideration of this feature for a future release.

DuckDB has just launched a new pg_duckdb extension and I want to use it in my PostgreSQL database to improve the performance in analytics. pg_duckdb is a Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features into Postgres. The GitHub repo: https://github.com/duckdb/pg_duckdb

Hi, This extension is released by Supabase and powers its webhook functionality. It enables asynchronous (non-blocking) HTTPS requests with SQL. We're a DigitalOcean customer and would love to build our app webhooks using this extension. https://github.com/supabase/pg_net Thank you.