As a user of PostgreSQL on Ubuntu, I work as a partner deploying the system while we design the particular system and deploy it using PostgreSQL on Ubuntu, which is a good fit in that way. PostgreSQL on Ubuntu is used primarily for a website, and the major case was only one time for small data marts for analytical purposes based on the website requirement. I have compared PostgreSQL on Ubuntu to solutions like SQL Matrix, which has a smaller variant, although I am trying to recall the exact name.
PostgreSQL on Ubuntu 24.04 LTS
Supported ImagesExternal reviews
4 reviews
from
External reviews are not included in the AWS star rating for the product.
Long-term web deployments have run reliably and now need better query editing tools
What is our primary use case?
What is most valuable?
From my experience, one of the biggest advantages of PostgreSQL on Ubuntu is that it is an RDBMS that performs well based on stability, and it is quick to set up and accessible, not demanding multiple editors or support tools, making it preferable for small-end website requirements.
The performance for parallel query execution on PostgreSQL on Ubuntu is good in my project, with no troubles yet based on the use cases that we deployed.
My experience with foreign data wrappers in PostgreSQL on Ubuntu is that they can connect queries to external data sources such as databases, files, and web services, which I find convenient. With open source technologies such as Python and Perl, we can write different libraries to quickly avail these features.
I do use ACID transactions in PostgreSQL on Ubuntu, which is RDBMS compliant, and it performs perfectly well with no difficulties encountered.
I find the installation process for PostgreSQL on Ubuntu to be easy, especially when applying it to data warehouse solutions, although I have limited experience with data marts.
What needs improvement?
In terms of areas for improvement in PostgreSQL on Ubuntu, the only thing is that on the editor side, they have to make it better, such as improving psql or similar PostgreSQL on Ubuntu editors to enhance functionality.
The editor side could be better, but the rest of PostgreSQL on Ubuntu is satisfactory.
For how long have I used the solution?
I confirm that I am using this product, PostgreSQL on Ubuntu, for four to five years.
What do I think about the stability of the solution?
I use multiversion concurrency control in PostgreSQL on Ubuntu, but some users look for a little variance when using it, especially in situations such as small online shops that require lighter solutions.
What do I think about the scalability of the solution?
I do not see any limits in scalability for PostgreSQL on Ubuntu; it scales well without constraints.
How are customer service and support?
Regarding technical support for PostgreSQL on Ubuntu, there is a need for quick support services when the solution is not built well, and community support is usually helpful in addressing queries and finding solutions to various scenarios.
Which solution did I use previously and why did I switch?
When I compare PostgreSQL on Ubuntu to competitors, I find they often offer lesser variants and better traction and use cases.
How was the initial setup?
I find the installation process for PostgreSQL on Ubuntu to be easy, especially when applying it to data warehouse solutions, although I have limited experience with data marts.
What was our ROI?
Regarding ROI from PostgreSQL on Ubuntu, I find it manageable, with it being affordable from a cost standpoint, although support may require additional variants depending on solution dependencies.
What's my experience with pricing, setup cost, and licensing?
The price model for PostgreSQL on Ubuntu is not expensive; it is affordable since most solutions we use are completely open source, leading to lower costs.
What other advice do I have?
Regarding BRIN indexes in PostgreSQL on Ubuntu, I have not used them for large data sets.
I have purchased solutions from AWS Marketplace depending on various customers, and I may have bought one or two solutions specifically related to PostgreSQL on Ubuntu in the past, though I do not clearly remember.
In fast development scenarios, we often use application lab models where we try out various combinations, helping us understand the scaling needs for PostgreSQL on Ubuntu and other deployments.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Postgres has supported fast POCs and now serves both transactional data and AI vector workloads
What is our primary use case?
I am currently working with Prometheus for observability on top of a platform, making Prometheus my main tool. In my past project, I used Contentful as a headless CMS for content delivery.
I use standard Postgres and Prometheus in my current project, with no other tools of that sort for other use cases. The choice of database depends on the project, but mostly for any POC that I do, I choose Postgres because of its simplicity. In the AI world, it has pgvector, an index store that is good for RAG systems.
Basically, a transaction DB in our application as well as a vector store for our RAG pipeline is my central use case.
What is most valuable?
The good aspect about PostgreSQL on Ubuntu is the huge community support that we have. PostgreSQL on Ubuntu is open source software, and different teams have contributed to open source. So it is quite robust in providing a lot of things. If you think about on-the-fly aggregations, it also supports that. Distributed clusters are also supported. It is a tool that is right now very mature and able to handle a lot of use cases. Coming from a SQL background, PostgreSQL on Ubuntu is the standard tool that we use. Most of my use cases are sometimes POCs that I need to deliver. At that point, it is a no-brainer to just use PostgreSQL on Ubuntu because of its simplicity and familiarity.
What needs improvement?
The initial setup can be tricky. If you are going for some advanced things and have a lot of data, then you also have to think a lot about how to set up the cluster. The infrastructure of the cluster is something that you need to consider if you are hosting a lot of data. For a general use case, it is fine, but when it comes to scaling, you have to pay a little attention to the cluster. This is true for other search services as well, where you have to think about similar kinds of considerations. With Algolia, you did not have to worry because it was managed by the service layer itself. Since this is a more hands-on tool, once the data comes in and the volume is high, then you must also think about the infrastructure.
For how long have I used the solution?
I have more than five years of experience with PostgreSQL on Ubuntu. My usage has been on and off.
What do I think about the stability of the solution?
I have not seen any stability issues with PostgreSQL on Ubuntu in my day-to-day work. Maybe something we have done to our services has caused the issue, but we have not seen a core PostgreSQL on Ubuntu issue. PostgreSQL on Ubuntu is quite stable.
What do I think about the scalability of the solution?
If you are dealing with multiple regions and huge data with huge transactions per second, in that case, you have to set up the cluster. It is not impossible. You just need to know the right cluster settings to set it up.
Which solution did I use previously and why did I switch?
I have used Amazon OpenSearch services as a tool for similar purposes.
How was the initial setup?
PostgreSQL on Ubuntu is very easy in terms of installation and deployment.
What about the implementation team?
I have not done it personally. My team has done it. My DevOps team has provisioned AWS instances as well as Azure instances. Under the hood, I do not know what I am dealing with. For me, it is just an IP address that I can SSH into and do it. Where the cloud is running, I know for sure they are using AWS and Azure interchangeably.
What was our ROI?
ACID transactions basically talk about write queries. Basically, if it is a distributed system, it makes sure that transaction consistency is there on each of the transactions that is happening. Think about if you are in a different geographic location and your cluster is hosted in two different geographic locations, maybe one in South Pacific and one in Western Europe. In both cases, if write transactions are happening, this is a good way to basically order the transactions so that the eventual data consistency is there.
With the basic version, you can very quickly do POCs. That is a very good ROI for that because suppose you have to do a demo in one week and you want to just quickly bootstrap some services and get the solution up. It is a very good service to do that. However, with different use cases, maybe different solutions are better. If you are going for an e-commerce solution where you have multiple filters available and you have to show aggregation, then a different type of query and a different type of database is needed.
What's my experience with pricing, setup cost, and licensing?
I am not using the Algolia service. I have purchased something from AWS Marketplace.
Which other solutions did I evaluate?
I was just looking at a service called ClickHouse. ClickHouse also has a different type of database. It is a clickstream analysis database. What we are trying to do is instead of Prometheus, we are thinking of using ClickHouse in our project because of how fast it is. Under the hood, it does a different type of operations to do aggregations, sums, and other operations. Since it is a SQL-based query system, the familiarity is there.
What other advice do I have?
My overall rating for PostgreSQL on Ubuntu is nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
College projects have gained powerful data management for structured and JSON workloads
What is our primary use case?
My main use case for PostgreSQL on Ubuntu is for storing the database, and I'm using Ubuntu because it is open source. Like multiple operating systems, it will support it because one of my friends and teammates has a MacBook. So, we cannot use the normal one.
A specific example of how I use PostgreSQL on Ubuntu in my work is in my project titled a student management and faculty leave student rating management system and faculty leave management system. Here I am working on a project where students are applying, students can give ratings for the faculties, and faculties can apply for leave applications for the admin side or as their upper faculty. I am storing the SQL data, such as creating the tables and this kind of data in PostgreSQL. As I mentioned, my friend's laptop is a MacBook, so we are creating PostgreSQL on Ubuntu. During my internship, I used PostgreSQL to handle structured data and perform operations such as joining, indexing, and data retrieval. I find it very stable and efficient when working with a large database. Additionally, there is no limit for the operating system because it is supported in all operating systems, with maximum database being unlimited RAM and unlimited database size. The license is open source, so it is easy to use. Installation is straightforward, and I can access the database easily. We can also create our own user and database. We can easily manage the database, and we can use NoSQL data as well.
What is most valuable?
The best features PostgreSQL on Ubuntu offers in my experience are zero cost, because it is totally free and has no limits from any user. I can easily understand this kind of SQL. Additionally, the maximum database is free and open source, as I mentioned. It has strong performance with large datasets and huge databases, runs smoothly on Ubuntu, and remains stable across all operating systems. It supports advanced features such as JSON and XML, and provides better control.
These features make my work easier and more efficient because some databases do not support JSON. For example, SQL Server 2014 will only support XML datasets, not JSON. Nowadays, we are storing our data or extending our data with JSON files, so PostgreSQL is easy to use for these needs. Furthermore, PostgreSQL is better because it provides backup functionality such as the pg_dump utility, allowing us to easily take backups from the PostgreSQL on Ubuntu database. We can also add extensions and enhance features. Overall, PostgreSQL on Ubuntu is a powerful and reliable database management system; it is easy to use and good for students who want to move beyond basic and industry-level skills.
PostgreSQL on Ubuntu has positively impacted my organization in terms of saving my time within my college project. It is easy to learn and understand how it is used, with easy installation and ease of use as it is a free and open-source tool, which means there is no need to pay any money or deal with licensing costs.
What needs improvement?
PostgreSQL on Ubuntu can be improved by providing some inbuilt AI agent mode, as nowadays many applications are offering such features. The installation process can sometimes be confusing for new users, as it mostly relies on terminal commands where a small mistake can create issues. A more guided and simplified installation process would be helpful, along with improved documentation so users can easily install and use it. Additionally, we can enhance GUI support and modify the GUI design of the tool. Tools such as pgAdmin are available, but they are not always smoothly integrated, so a more seamless graphical interface could be beneficial. Clear error messages and troubleshooting support are also necessary.
For how long have I used the solution?
I have used PostgreSQL on Ubuntu in my college project but I do not know exactly how long I have been using it.
What do I think about the stability of the solution?
PostgreSQL on Ubuntu is stable in my experience because at one time there are more than one user using PostgreSQL on Ubuntu, and it properly provides answers to every user. It is scalable for the users.
What do I think about the scalability of the solution?
PostgreSQL on Ubuntu is completely scalable.
How are customer service and support?
Customer support for PostgreSQL on Ubuntu is good, and I find it satisfactory.
Which solution did I use previously and why did I switch?
Before using PostgreSQL on Ubuntu, I first used MySQL on Ubuntu for a different project. I switched because PostgreSQL was suited for different kinds of projects I was working on.
How was the initial setup?
I saved time due to the ease of installation, but I did not have the chance to compare it to other databases I have tried in detail.
What about the implementation team?
PostgreSQL on Ubuntu is deployed for my projects as I am using it as a user for my college project, but I do not know how my organization uses the PostgreSQL server on Ubuntu.
What was our ROI?
I have seen a return on investment because if someone purchases the functionality, they will find it investable due to the many features it provides and the overall better product. However, as I have not done any purchasing myself, I cannot say it is perfect; I can say it is better based on what I am aware of.
What's my experience with pricing, setup cost, and licensing?
My experience with pricing, setup cost, and licensing for PostgreSQL on Ubuntu is based on the fact that I am using it as a free source, free open source. Therefore, I have never needed to consider pricing or licensing.
Which other solutions did I evaluate?
I did not evaluate other options before choosing PostgreSQL on Ubuntu, as I was not looking into other alternatives.
What other advice do I have?
I would add that compared to other tools, PostgreSQL is perfect. It is open source and free, has strong performance, and good stability. It has advantages for JSON, XML, indexing, and is better for stored procedures and triggers while being good for real-world applications in large datasets and backend development.
My advice for others looking into using PostgreSQL on Ubuntu is that if you need to store structured and non-structured data while utilizing modern features, you can use PostgreSQL because it is perfect for storing databases, especially when handling JSON and XML files. It is simply the best. I would rate my overall experience with PostgreSQL on Ubuntu as an 8 out of 10.
Reliable database has supported user growth and has delivered strong performance with low resource use
What is our primary use case?
PostgreSQL on Ubuntu is deployed as our application's database. Our application supports user registration, login, and other features that rely on a database. PostgreSQL stores artifacts, rules, strings, and all other data for our application. My setup and interaction with PostgreSQL on Ubuntu is standard with nothing unique to report.
What is most valuable?
PostgreSQL on Ubuntu offers reliability, performance, and cost-effectiveness, which were the primary factors in our decision to choose this database.
Regarding reliability and performance, I have not experienced any downtime, and the database has not shown any performance issues. The only challenge that arose was related to the growth of our own application; we had to tune our Postgres settings, but we could do this because of how flexible PostgreSQL on Ubuntu is. When configured correctly, PostgreSQL on Ubuntu demonstrates no performance issues.
PostgreSQL on Ubuntu has positively impacted our organization by providing software that seamlessly manages our database with our application. After reviewing alternatives, PostgreSQL on Ubuntu was the best fit for our needs.
Since implementing PostgreSQL on Ubuntu, I have noticed cost savings. While I cannot share metrics since we do not track them, we host our PostgreSQL within Docker images, and the resources used by those Docker images are consistently very low relative to all of the capabilities it provides.
What needs improvement?
PostgreSQL on Ubuntu can be improved in terms of flexibility, which comes at a cost—specifically its learning curve and complexity. This is not necessarily something that needs improvement, but it is something to consider when deciding which database to use. You need to invest significant time in learning PostgreSQL on Ubuntu. There is nothing related to documentation, support, or features I wish were easier to use.
For how long have I used the solution?
I have been using PostgreSQL on Ubuntu for almost eight years.
What do I think about the stability of the solution?
PostgreSQL on Ubuntu is stable.
What do I think about the scalability of the solution?
When configured correctly, PostgreSQL on Ubuntu is highly scalable.
How are customer service and support?
I have never used customer support for PostgreSQL on Ubuntu.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
I did not previously use a different solution.
How was the initial setup?
PostgreSQL on Ubuntu requires no license to use, and the setup cost is straightforward since we simply deploy a Docker image.
Which other solutions did I evaluate?
Before choosing PostgreSQL on Ubuntu, I did not evaluate other options.
What other advice do I have?
There is nothing related to extensions, security, or integration that I would like to mention.
My advice to others considering PostgreSQL on Ubuntu is to spend time learning how to tune the application to fit your performance and scalability needs; the earlier you do this, the easier it will be.
I would rate this product an 8 overall.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Robust relational queries have supported secure user data growth and improve transaction safety
What is our primary use case?
The main use case for PostgreSQL on Ubuntu is storing the database and serving as our primary database for storing the credentials of users and other information, including candidate data and enterprise data. This covers my main use case.
What is most valuable?
The best features PostgreSQL on Ubuntu offers are complex joins, which allow us to perform advanced SQL queries, providing the atomicity of our tables, ACID properties for transaction safety, and scalability that we can expand to, as we currently have 10 lakh users, and it is easily scalable.
Complex joins are the best feature that PostgreSQL on Ubuntu provides because I have been using NoSQL solutions such as MongoDB, but PostgreSQL has better efficiency for complex queries when used correctly.
PostgreSQL on Ubuntu has positively impacted our organization because, from the initial phase with around 1,000 plus users during user accessibility testing, we defined the tables in such a manner that even with future scalability increases, it would function well, and now it has grown to 10 lakh users, still holding up well with fast data retrieval and good query performance, supported by effective indexing methods.
In our user table with PostgreSQL on Ubuntu, we initially added indexing on the email property, but after a while, we found that the phone number field was also frequently used, and adding indexing to it improved our query retrieving speed and efficiency by almost 20 to 30 percent.
What needs improvement?
From an improvement perspective, the UI of PostgreSQL on Ubuntu can be somewhat better because from my experience, it is outdated compared to current UI generations, and the reliability without changing the entire system architecture can also be improved, along with optimizing index management such as adding proper indexes and removing unused ones.
Documentation for PostgreSQL on Ubuntu can also be improved because it is quite old and not easy for most people to understand, so that is one area that could see enhancement.
For how long have I used the solution?
I have been using PostgreSQL on Ubuntu since 1.5 years.
What do I think about the stability of the solution?
From my experience, PostgreSQL on Ubuntu is very stable for our application.
What do I think about the scalability of the solution?
The scalability of PostgreSQL on Ubuntu is very good because complex joins are performed smoothly and efficiently; just ensure that the database structure is well-defined from the start to scale from 1,000 users to 10 lakh users or any number of future users.
How are customer service and support?
So far, we have not needed customer support for PostgreSQL on Ubuntu, but my initial inquiry about it was good.
Which solution did I use previously and why did I switch?
We used to use Microsoft SQL, but it was costing us too much as the size of the database grew, which is why we switched to PostgreSQL on Ubuntu, where its internal B-tree optimization is quite good, making it sufficient for our application.
How was the initial setup?
Regarding pricing and setup costs for PostgreSQL on Ubuntu, I do not have much information about pricing, but the initial setup was very easy, with the more tedious aspects appearing later during scaling; licensing is simple since it is open-source.
What was our ROI?
The return on investment with PostgreSQL on Ubuntu is very good compared to commercial databases such as Oracle or Microsoft SQL due to zero licensing cost and lower infrastructure costs, making it about 40 percent less expensive than licensed enterprise databases, and since there are no upfront licensing fees, the ROI is increased with a scalable system without exponential cost growth.
Which other solutions did I evaluate?
We evaluated Microsoft SQL and Oracle databases before choosing PostgreSQL on Ubuntu.
What other advice do I have?
I would rate PostgreSQL on Ubuntu a solid nine or ten because it is very good for our application.
I chose a nine out of ten because while it is very robust, scalable, and cost-effective for RDBMS databases, one drawback is that it can be a complex setup for beginners, needing tuning for very high-scale workloads, which can be tedious if the sizes of queries and databases increase.
For anyone looking to use PostgreSQL on Ubuntu, it is ideal for applications that have a clear vision of their database and table structures, and it provides faster query searches, proving to be quite efficient, and it can also be used alongside other NoSQL solutions.
A mid-sized firm, a smaller firm, or a larger firm that wants to create an application should choose PostgreSQL on Ubuntu as it is the best choice; it is reliable, scalable, and requires thoughtful consideration of database and table structures to leverage its capabilities fully.
You should ask about how query optimization can be done and indexing strategies that PostgreSQL on Ubuntu provides, as these are important aspects to consider when using any SQL kind of databases.
I rate this product a nine out of ten overall.
Advanced queries have powered feature engineering and ensured reliable data analysis
What is our primary use case?
My main use case for PostgreSQL on Ubuntu is to query the database and the tables.
A quick specific example of a task where I used PostgreSQL on Ubuntu to query the database or tables is that I query the tables with SQL code, and it is very smart. I do feature engineering directly in SQL.
What is most valuable?
The best features PostgreSQL on Ubuntu offers include advanced queries. Its extensions are very smart, such as PostGIS. It is very smart and flexible.
The advanced query feature has helped me because I can use CTE and window functions, subqueries, and complex subqueries, providing great flexibility.
PostgreSQL on Ubuntu has positively impacted my organization by being very reliable. It has solid recovery and the risk of data loss is very low. It is very robust and ideal for production projects.
What needs improvement?
PostgreSQL on Ubuntu can be improved because it is a bit slower than other solutions I have used. I would also appreciate the ability to use the EXPLAIN ANALYZE tool.
What do I think about the stability of the solution?
PostgreSQL on Ubuntu is stable.
What do I think about the scalability of the solution?
PostgreSQL on Ubuntu's scalability is good.
How are customer service and support?
I have not had any experience with customer support.
Which solution did I use previously and why did I switch?
Before PostgreSQL on Ubuntu, I previously used MySQL, but it is inferior in comparison.
What was our ROI?
I have seen a return on investment with PostgreSQL on Ubuntu through time saving.
Which other solutions did I evaluate?
Before choosing PostgreSQL on Ubuntu, I evaluated MySQL as another option.
What other advice do I have?
Since using PostgreSQL on Ubuntu, I have seen specific outcomes such as being very solid with no loss of data, which saves time.
My advice to others looking into using PostgreSQL on Ubuntu is to use it to improve coding and to improve skills in feature engineering and in coding with window functions or data ingestion with JSON or the integration with Python, R, and Jupyter Notebook. I have given this review a rating of 8.
Hybrid data platform has delivered reliable transactions and powerful performance for our apps
What is our primary use case?
I was using a SaaS version of PostgreSQL on Ubuntu on both on-cloud and on-prem environments. We have a test server that is on-prem and certain production servers which are on the cloud. We use a mix of everything that works best for our needs. For example, we used an on-prem PostgreSQL on Ubuntu for the test server, but for production, we are using the cloud.
PostgreSQL on Ubuntu was used on Ubuntu for the backend of a lot of software. For example, the e-commerce software was built on top of PostgreSQL on Ubuntu.
What is most valuable?
One of the most important points about PostgreSQL on Ubuntu is that it is free. We do not have to worry about cost per core. It is a fully-featured database that supports a lot of features that modern applications need. In fact, it even supports document-based databases. It is quite a powerful solution.
The performance of PostgreSQL on Ubuntu's parallel query executions was very good. That is why we selected the solution.
We utilize ACID transactions with PostgreSQL on Ubuntu.
ACID transactions impact our data reliability in our work significantly. Reliability is very important and ACID helps us reach that goal. Regarding isolation specifically, our application did not require any specific isolation of transactions, but overall, ACID is still very important.
What needs improvement?
I did notice one downside about PostgreSQL on Ubuntu. Certain queries were not behaving in the same way that SQL Server was handling those queries. I found the handling of those queries done by SQL Server was slightly better than PostgreSQL on Ubuntu.
Maybe it makes more sense to use AI for configuration in future updates of PostgreSQL on Ubuntu so that the database is automatically optimized for the best performance for a given hardware. AI could be used for this purpose.
For how long have I used the solution?
I have been using PostgreSQL on Ubuntu for several years now.
What do I think about the stability of the solution?
PostgreSQL on Ubuntu is a stable solution.
Which solution did I use previously and why did I switch?
Before PostgreSQL on Ubuntu, I worked with MySQL and SQL Server.
We switched from MySQL to PostgreSQL on Ubuntu because PostgreSQL was giving us the features that we needed for free. If you have a paid solution that works well and you have a free solution that also works well, the obvious choice is the free solution because it works very well and it is free.
How was the initial setup?
The deployment of PostgreSQL on Ubuntu was quite straightforward.
The deployment took approximately one day.
What about the implementation team?
Only one person was involved in the process of deployment for PostgreSQL on Ubuntu.
What's my experience with pricing, setup cost, and licensing?
For the Software as a Service version, we were using PostgreSQL on Ubuntu and paid some amount. It was not a very large amount for PostgreSQL on Ubuntu. We were on the lowest tier, so it was around $5 or something.
What other advice do I have?
I cannot remember any specific example of using MVCC, but it is quite an important part of PostgreSQL on Ubuntu. It is a good-to-have feature.
I am satisfied with PostgreSQL on Ubuntu. We have worked with various databases including SQL Server and MySQL, but I found PostgreSQL on Ubuntu to be the most cost-effective and most performance-friendly solution. My rating for PostgreSQL on Ubuntu is 10.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Offers clear structure and reliable transactions but needs improvement in handling scalability
What is our primary use case?
We are working with Spring Boot and everything related to this area, using a couple of modules from Spring Boot such as security, data, and cloud. The most major aspect is that we work with relational database architecture.
For the relational database, I use PostgreSQL on Ubuntu.
I have been using PostgreSQL on Ubuntu for all my commercial experience, which is around six or seven years.
I use a relational database where objects and relations between them are needed, and where there is a specific structure. For example, if we have a parameter for our object, such as a user or an apple, we have specific size, weight, etc. Non-relational database is not about that; it's more about speed, but relational databases are specifically created for this task.
The support for complex data types such as JSON and XML in PostgreSQL on Ubuntu adds technical behavior not related to typical relational databases. I have worked with JSON in PostgreSQL on Ubuntu, and it helps manage non-structured data effectively. You can also add an index for JSON and speed up searches, though it's a complex topic that requires deep knowledge of how indexes work.
What is most valuable?
The best feature of PostgreSQL on Ubuntu is its structure because it adds clarity and understanding when investigating a database. This structure makes it more understandable than non-structural data, which enhances readability and understandability for someone new to the project.
I have utilized the advanced data replication features in PostgreSQL on Ubuntu. It provides a powerful mechanism for transactions, which is a huge achievement for relational databases.
The community around PostgreSQL on Ubuntu is awesome and perfect. Any question or issue can be resolved with quick Googling, and there are many knowledgeable people, which is really beneficial.
What needs improvement?
Asynchronous replication will help in managing data distribution and seeing benefits, but I'm not certain as I have not worked with such tasks in PostgreSQL on Ubuntu. I've resolved similar things in non-SQL databases such as MongoDB, but I haven't attempted those functionalities in PostgreSQL on Ubuntu due to their complexity.
For how long have I used the solution?
I have been using PostgreSQL on Ubuntu for all my commercial experience, which is around six or seven years.
What do I think about the stability of the solution?
The main benefits PostgreSQL on Ubuntu brings are stability and reliability, especially for transactions in companies handling money, which is crucial.
What do I think about the scalability of the solution?
The main disadvantages I see in PostgreSQL on Ubuntu relate to handling scaling. Vertical scale can work sometimes, but as databases grow, resources can become inadequate, leading to the need for complex replication and sharding which not every specialist is aware of.
Which solution did I use previously and why did I switch?
I have worked with other relational databases apart from PostgreSQL on Ubuntu.
How was the initial setup?
In the very beginning of my learning path, I faced some difficulties in setting up PostgreSQL on Ubuntu, but now it's clear how it works. I know all the steps to make it work: creating databases, making users, providing rules, and creating tables.
Which other solutions did I evaluate?
The main differences of PostgreSQL on Ubuntu in comparison to other competitors involve ACID compliance, where non-relational databases have made strides. However, non-relational databases often have sharding available by default, making them more comfortable for dividing information. They also tend to be faster and fit for blob storage, but it's not the best way for storing files, as I prefer dedicated storage solutions such as S3 or Azure Blob Storage.
What other advice do I have?
My advice for organizations considering PostgreSQL on Ubuntu is to thoroughly discuss their project needs, as it depends on their specific requirements. Spending time discussing future goals and project needs is crucial before making any decisions about a database, because changing databases during a project can be difficult and resource-intensive.
The structure and design of the database as it stands are really nice.
I haven't escalated any questions or issues regarding technical support with PostgreSQL on Ubuntu.
I don't remember anything about PostGIS capabilities.
On a scale of 1-10, I rate PostgreSQL on Ubuntu a 7.
Handles high-demand database operations efficiently and offers significant cost savings
What is our primary use case?
We use PostgreSQL on Ubuntu for storing our data related to high court cases.
What is most valuable?
The best advantage of PostgreSQL on Ubuntu is its ability to fulfill all our requirements as an RDBMS. We frequently use various database-related operations such as storing, retrieving, and utilizing views and triggers. Its concurrency and connection handling are very efficient, especially since we have around 1,000 users.
What needs improvement?
We have not faced any errors, and for our purposes, PostgreSQL on Ubuntu is working perfectly. However, integrating AI features for analytical data generation might be beneficial as our processes are increasingly dependent on AI tools.
For how long have I used the solution?
We have been using PostgreSQL since 2018.
What do I think about the stability of the solution?
I have found PostgreSQL on Ubuntu to be a very stable product.
What do I think about the scalability of the solution?
PostgreSQL on Ubuntu is very scalable with no restrictions.
How are customer service and support?
We have not utilized customer support, as we generally obtain information from publicly available sources.
How was the initial setup?
The initial setup is quite easy to install, with the documentation being very well-organized. We do it ourselves without needing external technical assistance.
What about the implementation team?
We handle the installation ourselves.
What was our ROI?
We find the solution able to make savings of around 10% to 20%, depending on the solution being used.
What's my experience with pricing, setup cost, and licensing?
PostgreSQL on Ubuntu is free of cost. We are not purchasing anything additional.
What other advice do I have?
I would rate PostgreSQL on Ubuntu as a ten out of ten. The only suggestion for improvement is to add AI features.
showing 1 - 9