EDB Postgres AI Cloud Service

Our primary use case for EDB Postgres Advanced Server  was to study the code base behind it. We aimed to understand how it has been built, how the engine functions, the querying process, and what kinds of indices are available. This was part of our college projects where we explored its architecture and capabilities.

The number of indices available in Postgres is remarkable. Additionally, the way it forks each process into a child node, instead of executing in the same node, is quite different from most databases. These features can be especially useful in certain scenarios compared to MySQL  or other SQL-based databases. Also, the ability to distribute the database across different machines is a significant advantage.

It was challenging to think of improvements for Postgres. We did not choose to extend or add new features to Postgres since it already meets our needs so well. There aren't specific new features we wish to add.

I have had experience with this product for the past year.

Postgres and MySQL  are known for their stability and reliability, which is essential for a product server.

Although I do not have detailed insight into MySQL's scalability, I can affirm that Postgres scales effectively and performs exceptionally well among SQL databases.

Postgres has excellent documentation, which is very comprehensive and includes diagrammatic representations and visual aids. This makes learning and understanding the system much easier.

Positive

Setting up MySQL is slightly more straightforward than Postgres. I would rate the Postgres setup experience as seven and a half out of ten, compared to MySQL's setup, which I rate at nine out of ten.

I would highly recommend EDB Postgres Advanced Server  to others. Most companies prefer Postgres or MySQL for a reason. The number of available options and the ability to distribute the database across different machines enhances its flexibility and features. 

I rate Postgres a nine out of ten overall.

I am a lecturer, and in universities, we use EDB Postgres Advanced Server  to start with databases for practical purposes. I also assist with migrations, especially when clients want to migrate from Oracle to Postgres. So, while I am not a regular user, I am involved during migrations.

Since the initial cost of licensing is lower compared to Oracle, this is a benefit for our clients, particularly in the healthcare sector where I work with systems like the Visuraj Dashboard and appointment booking infrastructure. Maintenance is easier without needing third parties, thanks to EDB support.

The feature of vector database management for AI is quite interesting and impactful. Clients often compare it with other databases, such as ChromaDB. Additionally, the compatibility with Oracle is beneficial for middle—and lower-tier customers. EDB offers extensive support, low initial licensing costs, and comprehensive packages.

I would like to see improvements in the performance, especially in large-scale operations, as it currently cannot match Oracle's performance. Additionally, multi-tenancy architecture, microservices, and container-based architecture support are needed. Enhancements should be made in AI support and vector database features.

I have been involved with EDB Postgres Advanced Server  in situations related to Oracle and Postgres migrations. It is not a continuous engagement, but I have supported the solution whenever needed.

Their technical support is quite good. Even for installation issues, support is readily available and competent.

Neutral

Installation is quite straightforward and easy, unlike Oracle. It's simple, just taking five minutes.

EDB Postgres Advanced Server offers both processor-based and user-based licensing options. The cost is reasonable, particularly for middle and lower-tier customers, but there are hiccups when dealing with large enterprises whose data exceeds one hundred terabytes.

For high-end, large enterprises, we recommend Oracle as it offers better performance.

I recommend EDB Postgres Advanced Server for middle—and lower-tier businesses. Its ease of installation makes it beneficial from a learning perspective. However, due to performance issues, Oracle remains the best choice for high-end enterprises.

I'd rate the solution seven out of ten.

There are no specific use cases associated with the product. For my personal use, I installed EDB Postgres Advanced Server. When I was learning about databases, I installed EDB Postgres Advanced Server, specifically when I was playing around with queries. I am not working on any use cases with the tool.

The solution's most valuable feature is the pgAdmin part, which includes a dashboard showing the metrics associated with Postgres.

The product currently fails to offer a mobile application. In the future, I want the solution to offer a mobile application, especially since you can access the services via mobile phone with all the service providers like AWS and others. A mobile application provided by the product can help a user to see the status whenever needed.

I have been using EDB Postgres Advanced Server since 2016 or 2017.

Until and unless you pump in a lot of data, you cannot figure out the tool's stability. For my usage, I don't see any problems with the product's stability. Stability-wise, I rate the solution a seven out of ten. You will get to know about the stability of the product only when you use terabytes of data.

I cannot comment on the scalability of the product since it can only be determined once the amount of data used in the product increases.

As it is an open-source product, I did not get any technical support.

The product's deployment phase is easy.

The solution can be deployed in five to ten minutes.

The solution can be deployed by myself.

It is an open-source product.

The product is user-friendly.

I recommend the product to others.

I rate the solution a seven out of ten.

The product is fast. I have used SQL Server before, and considering that Postgres is open source, its speed is remarkable. It's as fast as a proprietary server like SQL Server or Oracle. Additionally, it has many built-in features that make scripting easy.

It has good stability. I rate it an eight out of ten.

It is quite scalable. I rate it a nine out of ten.

The documentation is excellent. It covers everything you need to know, including how the features work and how to set everything up. Overall, it's very straightforward. 

Positive

The setup is straightforward, similar to a general setup. Someone with experience with other database software like Oracle or SQL Server won't need to learn anything new to set up Postgres. It's really easy to set up. Setting up any database can be challenging for a first-time user, but even someone with minimal experience can do it easily. 

I rate it an eight out of ten.

It's a cost-saving option if you're cost-conscious and want to avoid using SQL Server or Oracle, both of which I've used in the past three or four years and know can be expensive. It's cost-effective and gets the job done. From my experience, it's as fast as SQL Server, though not quite as fast as Oracle. I would choose this option if I had to choose between this and other providers.

It is free. You need to invest in the infrastructure to run the server, but it is free to set up anywhere.

Postgres is highly compatible with many software and programming languages. Its compatibility is excellent, covering nearly everything related to data engineering or migration.

They have some particular features that differ from Postgres, so there is an initial learning curve. Some features, like scripting, might vary from other database servers. There could be a slight learning curve for new users. It is the best open-source database server available.

It's good for machine learning or AI. The data processing needs are well-handled, and Postgres is relatively fast at retrieving, inserting, or modifying data. It will be helpful for these purposes.

Overall, I rate it around nine out of ten.

I have faced performance issues in the community edition. 

I have been working with the solution for four years. 

I rate EDB Postgres Advanced Server's stability an eight out of ten. 

We didn't get any support and used Google to search about issues. 

I have been working on the community edition. 

I rate EDB Postgres Advanced Server a nine out of ten.