PostgreSQL on Ubuntu 24.04 LTS

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.

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.

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.

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.

I have more than five years of experience with PostgreSQL on Ubuntu. My usage has been on and off.

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.

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.

I have used Amazon OpenSearch  services as a tool for similar purposes.

PostgreSQL on Ubuntu is very easy in terms of installation and deployment.

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.

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.

I am not using the Algolia  service. I have purchased something from AWS Marketplace .

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.

My overall rating for PostgreSQL on Ubuntu is nine out of ten.

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.