PostgreSQL on Ubuntu Reviews

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.

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.

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.

I confirm that I am using this product, PostgreSQL on Ubuntu, for four to five years.

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.

I do not see any limits in scalability for PostgreSQL on Ubuntu; it scales well without constraints.

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.

When I compare PostgreSQL on Ubuntu to competitors, I find they often offer lesser variants and better traction and use cases.

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.

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.

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.

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.

Public Cloud

Amazon Web Services (AWS)

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.

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.

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.

I have been using PostgreSQL on Ubuntu for all my commercial experience, which is around six or seven years.

The main benefits PostgreSQL on Ubuntu brings are stability and reliability, especially for transactions in companies handling money, which is crucial.

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.

I have worked with other relational databases apart from PostgreSQL on Ubuntu.

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.

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.

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.

My main use case for PostgreSQL on Ubuntu is precisely the database aspect, which is the storage of data from applications that run on top of Ubuntu.

We have an application that uses PostgreSQL on Ubuntu that we sell to end customers, and we run the entire environment on Ubuntu. We have a dedicated Ubuntu machine running PostgreSQL and storing all the data there.

This environment, which includes PostgreSQL on Ubuntu, was set up in the cloud. We have one machine for the application and another dedicated one for the database, which in this case is PostgreSQL. We have all the backup routines for this database. It connects to the database, performs the entire backup, and that is our standard process.

The best features that PostgreSQL on Ubuntu offers are the flexibility aspect, which is phenomenal. Being open source also helped significantly in its adoption. Since it is one of the market leaders when it comes to relational databases, it was definitely our best choice. We have excellent reliability, and with each new version, we are confident that we won't have problems with upgrades; we never have. It delivers everything we need, which is precisely reliability, frequent updates, flexibility of use, ease of use, and the advantage of being a market-leading tool.

PostgreSQL on Ubuntu, because it is widely used and open source, has great acceptance in educational environments, including universities and technical courses. Programmers and developers are already accustomed to using PostgreSQL, running queries, and interacting with it. Even junior developers and interns who are joining the development team have already had contact with PostgreSQL, so the learning curve for the team is relatively very fast. They already come in with excellent background knowledge, and we don't have major difficulties finding developers who have already worked with PostgreSQL.

The main points about PostgreSQL on Ubuntu are that it is open source, allows flexibility, has great adoption with a very large market share, includes many features natively, provides frequent updates, and delivers the reliability we need for our applications. Every time we have performed upgrades, we have never had any problems.

One of the main improvement points for PostgreSQL on Ubuntu would be that the team, even though it is an open source solution, could have more events and meetups promoted by PostgreSQL itself and by the PostgreSQL team, with companies and developers in the main commercial centers of the world. Focusing on Brazil, in the main capitals as well, they should promote, encourage, and publicize these events more so that this technology and solution are spread even further.

I have been using PostgreSQL on Ubuntu for more than three years.

PostgreSQL on Ubuntu is extremely stable.

PostgreSQL on Ubuntu has very good scalability, allowing you to scale from small applications to large applications in a consistent way.

Regarding official support for PostgreSQL on Ubuntu, because it is an open source tool, there are support plans and subscriptions dedicated to the solution, but in our case, we did not need to sign up for any.

We have always used PostgreSQL on Ubuntu and did not previously use a different solution.

I performed the installation of PostgreSQL on Ubuntu separately, rather than acquiring it through the AWS Marketplace.

The best return on investment with PostgreSQL on Ubuntu is that since it is a widely used market solution in enterprise environments, we have a reduction in training costs for employees. Because the solution itself does not generate any acquisition or usage costs, the main costs that would be associated are for the workforce itself, specifically the developers. Since they already have contact with this tool in educational environments, the cost is truly the best of both worlds.

My experience with pricing, setup costs, and licensing for PostgreSQL on Ubuntu has been excellent. Because it is an open source solution, we did not have acquisition or usage costs for this solution.

We evaluated MySQL and Microsoft's SQL Server before choosing PostgreSQL on Ubuntu. PostgreSQL was our choice precisely because it is an open source solution with no licensing costs and already has a very high market share.

PostgreSQL's stability is a very relevant positive impact that I can share as a specific example of measurable impact. We have a truly robust open source solution for which we do not have licensing costs, even for corporate use, and which delivers incredible reliability. We do not have difficulties with deployment, maintenance, or anything else. It delivers what we need for our application. When a database is very well modeled and structured, it brings together what is useful and what is pleasant, and we have an application that does not present problems with the database.

My advice for others who are considering using PostgreSQL on Ubuntu is that if your application is relational, that is, if you need a relational database, PostgreSQL will definitely be my first recommendation. I would rate this solution a perfect ten out of ten.

Public Cloud

Amazon Web Services (AWS)

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.

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.

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.

I have been using PostgreSQL on Ubuntu for almost eight years.

PostgreSQL on Ubuntu is stable.

When configured correctly, PostgreSQL on Ubuntu is highly scalable.

I have never used customer support for PostgreSQL on Ubuntu.

I did not previously use a different solution.

PostgreSQL on Ubuntu requires no license to use, and the setup cost is straightforward since we simply deploy a Docker image.

Before choosing PostgreSQL on Ubuntu, I did not evaluate other options.

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.

Public Cloud

Amazon Web Services (AWS)

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.

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.

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.

PostgreSQL on Ubuntu is stable.

PostgreSQL on Ubuntu's scalability is good.

I have not had any experience with customer support.

Before PostgreSQL on Ubuntu, I previously used MySQL, but it is inferior in comparison.

I have seen a return on investment with PostgreSQL on Ubuntu through time saving.

Before choosing PostgreSQL on Ubuntu, I evaluated MySQL as another option.

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.

On-premises

Other

My main use case for PostgreSQL on Ubuntu is developing applications and using PostgreSQL on Ubuntu as my backend for my data storage.

A quick specific example of an application where I used PostgreSQL on Ubuntu for data is an application that was used to help match borrowers with available mortgage lenders and determine which lender is most likely to lend to those borrowers.

The best features PostgreSQL on Ubuntu offers are deep integration to JSONB fields and indexing within those fields, which is extremely useful in my use case.

The deep integration with JSONB fields and indexing has helped my use case by allowing us to use a number of specific entries in dictionaries that are stored in JSONB fields, and by using the indexing within JSONB fields, we're able to use those fields directly and efficiently without having to manually create additional fields for searching.

PostgreSQL on Ubuntu has positively impacted my organization by allowing us to overcome the performance issues we faced while running PostgreSQL on Ubuntu in a different environment, Windows-based, which was not as performant and required a lot more memory and CPU bandwidth than our eventual Ubuntu deployment.

To improve PostgreSQL on Ubuntu, I think providing some more comprehensive JSONB field indexing would be useful and perhaps cleaning up some of the syntax around it, which is a little unusual.

I have been using PostgreSQL on Ubuntu for about ten years.

PostgreSQL on Ubuntu seems to work very smoothly.

After switching to Ubuntu, I experienced performance improvements mostly in resource savings, where the memory overhead dropped down to under five hundred megabytes for standard operations, although with all indexes and so on loaded, we usually kept the machine running at about one gigabyte.

My advice to others looking into using PostgreSQL on Ubuntu is that assuming you need an SQL-type database, it would be my first pick.

Regarding PostgreSQL on Ubuntu's AI capabilities, my thoughts on its accuracy and reliability of output are positive so far.

I would rate PostgreSQL on Ubuntu a nine overall on a scale of one to ten.

We use PostgreSQL on Ubuntu for storing our data related to high court cases.

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.

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.

We have been using PostgreSQL since 2018.

I have found PostgreSQL on Ubuntu to be a very stable product.

PostgreSQL on Ubuntu is very scalable with no restrictions.

We have not utilized customer support, as we generally obtain information from publicly available sources.

Neutral

The initial setup is quite easy to install, with the documentation being very well-organized. We do it ourselves without needing external technical assistance.

We handle the installation ourselves.

We find the solution able to make savings of around 10% to 20%, depending on the solution being used.

PostgreSQL on Ubuntu is free of cost. We are not purchasing anything additional.

I would rate PostgreSQL on Ubuntu as a ten out of ten. The only suggestion for improvement is to add AI features.

Hybrid Cloud

Other

My main use case for PostgreSQL on Ubuntu is that we were looking for a Linux environment and that's how Ubuntu became our choice.

The best features PostgreSQL on Ubuntu offers, based on my experience, were the documentation and ease of use. The Ubuntu documentation made it easier to use and install.

PostgreSQL on Ubuntu positively impacted my organization by speeding up the test environment at the time. It sped up my test environment by being faster to set up and to maintain.

I don't remember how PostgreSQL on Ubuntu can be improved as it was too long ago. I'm not aware of any improvements needed for PostgreSQL on Ubuntu that I haven't mentioned.

I've been using PostgreSQL on Ubuntu for maybe one or two years.

It worked well regarding my experience with PostgreSQL on Ubuntu. It was easy to use and well documented, which is what I appreciated.

There were no scalability issues, especially because we did not test the performance or integration features of PostgreSQL on Ubuntu.

I don't have any advice regarding PostgreSQL on Ubuntu because I don't use it and don't have an opinion. I don't have any additional thoughts about PostgreSQL on Ubuntu to share. My review rating for this product is 8.

Public Cloud

Amazon Web Services (AWS)