EDB Postgres AI Platform
Consistent report views have unified metrics and validate complex data queries with confidence
What is our primary use case?
My main use case for EDB Postgres Advanced Server is organizing data queries for analysis. I use SQL to combine information from different tables, apply business rules, and prepare datasets for reporting.
I also use PostgreSQL on the results first. I run validations, such as checking the number of records and verifying whether any join caused duplicates. This helps me feel more confident that the report numbers reflect the source data.
One specific example of using EDB Postgres Advanced Server to solve a data analysis challenge is a report that shows the number of records by month and by category. In EDB Postgres Advanced Server, I use SQL to join the main table with the categories table and calculate the totals. Before passing the result to the report, I verify that this join did not duplicate any records and that the sum by category matches the total of the base table. This way, I can compare the months with more confidence.
One step I consider important in my primary use case for EDB Postgres Advanced Server is defining what each row should represent before joining the tables. For example, if the report needs to count customers, I check whether a customer appears multiple times because they have more than one transaction. In EDB Postgres Advanced Server, I use SQL queries to check this before consolidating the data. This validation prevents the report from showing an inflated total, even when the query runs without any errors.
How has it helped my organization?
The main benefit I noticed from EDB Postgres Advanced Server was the consistency of the reports. When two reports needed to show the same indicator, I could reuse a view in EDB Postgres Advanced Server with the calculation rule already defined. This way, both used the same criteria. If the rule changed, I had a central point to update it.
This also made it easier to investigate discrepancies. If a total came out different from what I expected, I could check at which step of the query the difference appeared. I don't have a precise and formal measurement of time saved, but in my daily work it became easier to keep reports aligned and validate the numbers before delivery.
What is most valuable?
In my experience, the best features of EDB Postgres Advanced Server are useful for data analysis. The features that help me most are views and CTEs. With views, I can reuse the same logic across several reports. For example, if two reports need to count active customers, I can centralize that rule in a view so both use the same criteria.
CTEs help me break a complex query into steps. I can filter the data first, join the tables, and only then calculate the totals. If the result differs from what I expected, I can check each step and identify where a duplicate appeared or where a record was omitted.
Compared with BigQuery, using views and CTEs in EDB Postgres Advanced Server felt familiar. CTEs help me separate filters, joins, and calculations into steps that I can validate one by one. Views are useful when the same business rule needs to be used in more than one report. For me, the clearest gain was in maintainability. It is easier to find where a total difference came from and to fix a rule that several reports use.
What needs improvement?
In my opinion, EDB Postgres Advanced Server could be improved in the experience of investigating slow queries. For people who work more with data analysis, it would be useful to have practical examples of how to read the execution plan and decide where to start.
For example, when a query that joins several tables becomes slow, I would want a guide that shows how to identify the step that takes the most time and what to check before changing the query or suggesting an index. This would help test one hypothesis at a time and measure whether the change actually improved performance.
For how long have I used the solution?
I have been using EDB Postgres Advanced Server since 2021.
What do I think about the stability of the solution?
EDB Postgres Advanced Server is stable. I have never had any instability or any other problem with it.
What do I think about the scalability of the solution?
I am also pleased with the scalability of EDB Postgres Advanced Server. I think it is very good, very useful, fast, easy to use, and reliable.
How are customer service and support?
I have also never had any problems with EDB Postgres Advanced Server customer support. When the company or I needed to request support, it was always fast. They responded in a timely manner, so I have nothing to complain about.
Which solution did I use previously and why did I switch?
I have used several different tools before, both at previous companies and for studying, academically, at university, in postgraduate studies, and so on. However, I have always used PostgreSQL for SQL queries and data preparation.
I started using EDB Postgres Advanced Server because it was the database available on the project where I needed to prepare and validate data for reports, etc. Since I already knew PostgreSQL, I was able to apply my experience with queries, views, and CTEs.
How was the initial setup?
I accessed EDB Postgres Advanced Server in my organization to run queries and prepare data for reports, as I have been saying. My role was in data analysis.
Which other solutions did I evaluate?
I am just a user.
What other advice do I have?
I would rate EDB Postgres Advanced Server a nine.
I give EDB Postgres Advanced Server a nine because it meets my primary use case well: preparing and validating data for reports. Views help me maintain the same calculation rule, as I've already mentioned, across several reports. CTEs make it easier to verify each step of a query when a total comes out different from what I expected.
To reach a 10, I would want to find more practical examples, within the tool itself, of how to investigate slow queries. For example, as I already mentioned, a guide that shows how to read the execution plan of a query that joins several tables, identify where it spends the most time, and verify whether a change really improved performance.
To others considering EDB Postgres Advanced Server, I would recommend it.
I would recommend EDB Postgres Advanced Server to companies looking for a robust, secure, and scalable database, especially in corporate environments with large data volumes. Before adoption, I would advise running a proof of concept to evaluate performance, compatibility with existing systems, and licensing costs.
I also consider it important to explore its security, monitoring, and automation features, and to have a qualified team to take full advantage of the tool's potential.
Clustered billing has reduced downtime and costs but still needs better monitoring and AI features
What is our primary use case?
My main use case for EDB Postgres Advanced Server is that we have a telecommunication billing product where I am using it as a backend database to handle all the requests.
A specific example of how we use EDB Postgres Advanced Server in our billing product is that customers recharge their phone numbers for data packs and SMS packs, and we use it as a backend solution mostly related to the billing part.
Regarding my main use case for EDB Postgres Advanced Server, we use the HA part to handle all the transactional related things.
What is most valuable?
The best features EDB Postgres Advanced Server offers, in my experience, is providing us with the cluster features to fail over and fail back the nodes easily in production without any downtime, which helps to run our production very smoothly compared to the challenges we face with community versions.
Failover and clustering have made a big difference for my team during production incidents or maintenance; for example, with EDB's EFM cluster, smoothly failing over from one node to another for maintenance is a prime feature of EDB Postgres Advanced Server that allows us to do this efficiently.
In terms of features, I think EDB Postgres Advanced Server performs better than the community version, with helpful support in case any issues occur, and the other products EDB provides are also very useful.
EDB Postgres Advanced Server has positively impacted my organization by being cost-saving compared to databases such as Oracle, while providing smooth performance that simplifies production operations with less downtime and effort, especially in a cloud environment where we can utilize containerized services.
What needs improvement?
For improvement purposes, I think EDB Postgres Advanced Server needs some enhanced monitoring since the current default monitoring is not sufficient; an EDB monitoring tool could provide useful metrics to help end users avoid production issues.
Additionally, there is a lack in documentation, which tends to be scattered, making it difficult for end users to find clear guidance during setup, especially with new containerized features.
Regarding EDB Postgres Advanced Server's AI capabilities, I see a lag in its initiatives on the AI front, and I have not explored much of its security features related to AI.
For how long have I used the solution?
I have been using EDB Postgres Advanced Server for the last five years in both production and non-production environments, and I do explore multiple products from EDB.
What do I think about the stability of the solution?
EDB Postgres Advanced Server has been stable in my experience, and we have not faced major issues in production setup or clustering; EDB support has been helpful whenever required.
What do I think about the scalability of the solution?
EDB Postgres Advanced Server is scalable, allowing us to easily scale up or down as our needs change.
How are customer service and support?
The customer support for EDB Postgres Advanced Server is really good, and we can access it quickly.
Which solution did I use previously and why did I switch?
Before using EDB Postgres Advanced Server, we were using Oracle, but we switched due to its high costs and infrastructure setup.
How was the initial setup?
For setting up the EDB cluster, it is really good, time-efficient, and efficient. I really recommend setting up EDB in the production environment.
What was our ROI?
We have seen a return on investment with significant money and time saved; for instance, setting up a database for one client saved us a lot of dollars and allowed us to deploy quickly with containerization.
What's my experience with pricing, setup cost, and licensing?
My experience with pricing, setup costs, and licensing for EDB Postgres Advanced Server is that it is very cost-efficient, easy to set up, and can be deployed in a containerized manner.
Which other solutions did I evaluate?
We evaluated other options such as MySQL, but we needed enterprise support for production use, which EDB Postgres Advanced Server provided reliably.
What other advice do I have?
My advice for others looking into using EDB Postgres Advanced Server is that setting up the EDB cluster is efficient and time-effective, making it a recommended choice for production environments.
EDB Postgres Advanced Server is deployed in my organization via multiple setups, including an on-premise setup, hybrid setup, and public cloud setup in AWS.
For improvements, I think EDB should initiate a program to create an RDS for EDB Postgres Advanced Server with a bring-your-own-license option to avoid high charges compared to AWS Aurora.
For accuracy and reliability of output, I rate EDB Postgres Advanced Server a seven out of ten, and I am satisfied with the EDB products I am using and plan to deploy in future digital products.
Centralized management has reduced database overhead but pricing and documentation have needed work
What is our primary use case?
The main use case for EDB Postgres Advanced Server (EPAS) is within my work at DBtune, an AI-driven SaaS product for database optimization. I am responsible for developing and testing our platform's integration with various database environments, including Azure, AWS, and EDB's EPAS and CNPG solutions, ensuring our SaaS can seamlessly connect and optimize them.
What is most valuable?
What I appreciate about EDB Postgres Advanced Server is that it offers management tools such as PEM and CNPG under one umbrella, providing enterprise features that eliminate the need for multiple engineers to maintain PostgreSQL databases, although it is somewhat expensive.
I evaluate the technical support and customer service of EDB Postgres Advanced Server as really good, as I have sought their help three to four times regarding issues with PEM configuration, and they respond quickly and solve issues promptly. I would rate the technical support of EDB Postgres Advanced Server an 8 out of 10.
EDB Postgres Advanced Server's high availability and disaster recovery features, specifically the introduction of CNPG based on Kubernetes, are good, but they require significant infrastructure overhead, which I believe necessitates a lightweight integration model for better performance.
I rate the efficiency improvements from EDB Postgres Advanced Server a 10 out of 10 when it comes to Oracle compatibility. Its native support for Oracle's PL/SQL syntax makes evaluating and migrating legacy workloads incredibly smooth, bypassing the typical headaches of manual code rewrites.
What needs improvement?
Beyond the aspects that I mentioned about the enterprise manager PEM and UI complexities, I would like to see improvements in the pricing structure to accommodate startups and clearer centralized documentation for those less familiar with EDB Postgres Advanced Server.
For how long have I used the solution?
Overall, I have used EDB Postgres Advanced Server for around one year.
What do I think about the stability of the solution?
When assessing the stability performance of EDB Postgres Advanced Server, I can say it is quite good, with occasional performance issues not attributed to EDB Postgres Advanced Server but rather to application conflicts.
What do I think about the scalability of the solution?
Regarding scalability, I find that EDB Postgres Advanced Server supports scalability well with features such as multimaster, PGD, and automated systems, allowing for easy adjustments to storage and operations, which I would rate a 9 out of 10.
Which solution did I use previously and why did I switch?
Prior to adopting EDB Postgres Advanced Server, I used the open-source version of PostgreSQL and have experience with Oracle, which remains the top database in my opinion.
How was the initial setup?
The initial setup process for EDB Postgres Advanced Server is quite straightforward for me, but I recognize it may be complex for developers who are new to databases due to less clear documentation from a few years ago.
What's my experience with pricing, setup cost, and licensing?
We obtained EPAS through our partnership with EDB using an enterprise deployment model on-premises. From a pure testing perspective for a startup like DBtune, the licensing can feel quite expensive. However, for true enterprises, it is well worth the investment because the built-in management tools and excellent support mean you don't need a massive team of engineers just to maintain the architecture.
What other advice do I have?
From a pricing perspective, I do not find it cost-effective from DBtune's SaaS perspective as we are just testing it, but for enterprises, it is worth it as you do not require many engineers for management and receive good support. I do not have experience using EDB Postgres Advanced Server's advanced security features as I have not had the opportunity to utilize them, despite my awareness of their existence.
We did not use the partitioning feature from EDB Postgres Advanced Server, so I do not have experience with that.
We use the enterprise deployment model for EDB Postgres Advanced Server, which we obtained through our partnership with EDB.
My experience with EDB Postgres Advanced Server is quite recent as I have used it in early 2026, along with CloudBeaver, which I recently utilized in 2026 as well.
My overall rating for this review is 7 out of 10.
Explore innovative database indexing and distributed architecture capabilities
What is our primary use case?
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.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have had experience with this product for the past year.
What do I think about the stability of the solution?
Postgres and MySQL are known for their stability and reliability, which is essential for a product server.
What do I think about the scalability of the solution?
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.
How are customer service and support?
Postgres has excellent documentation, which is very comprehensive and includes diagrammatic representations and visual aids. This makes learning and understanding the system much easier.
How was the initial setup?
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.
What other advice do I have?
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.
Enhancing database learning with AI features and Oracle compatibility but needs performance improvements
What is our primary use case?
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.
How has it helped my organization?
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.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
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.
How are customer service and support?
Their technical support is quite good. Even for installation issues, support is readily available and competent.
How was the initial setup?
Installation is quite straightforward and easy, unlike Oracle. It's simple, just taking five minutes.
What's my experience with pricing, setup cost, and licensing?
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.
Which other solutions did I evaluate?
For high-end, large enterprises, we recommend Oracle as it offers better performance.
What other advice do I have?
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.
Though user-friendly, it fails to offer a mobile application to users
What is our primary use case?
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.
What is most valuable?
The solution's most valuable feature is the pgAdmin part, which includes a dashboard showing the metrics associated with Postgres.
What needs improvement?
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.
For how long have I used the solution?
I have been using EDB Postgres Advanced Server since 2016 or 2017.
What do I think about the stability of the solution?
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.
What do I think about the scalability of the solution?
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.
How are customer service and support?
As it is an open-source product, I did not get any technical support.
How was the initial setup?
The product's deployment phase is easy.
The solution can be deployed in five to ten minutes.
What about the implementation team?
The solution can be deployed by myself.
What's my experience with pricing, setup cost, and licensing?
It is an open-source product.
What other advice do I have?
The product is user-friendly.
I recommend the product to others.
I rate the solution a seven out of ten.
A open-source database with built-in features for scripting
What is most valuable?
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.
What do I think about the stability of the solution?
It has good stability. I rate it an eight out of ten.
What do I think about the scalability of the solution?
It is quite scalable. I rate it a nine out of ten.
How are customer service and support?
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.
How would you rate customer service and support?
Positive
How was the initial setup?
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.
What was our ROI?
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.
What's my experience with pricing, setup cost, and licensing?
It is free. You need to invest in the infrastructure to run the server, but it is free to set up anywhere.
What other advice do I have?
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.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Community edition comes with performance issues
What needs improvement?
I have faced performance issues in the community edition.
For how long have I used the solution?
I have been working with the solution for four years.
What do I think about the stability of the solution?
I rate EDB Postgres Advanced Server's stability an eight out of ten.
How are customer service and support?
We didn't get any support and used Google to search about issues.
What's my experience with pricing, setup cost, and licensing?
I have been working on the community edition.
What other advice do I have?
I rate EDB Postgres Advanced Server a nine out of ten.