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.
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.
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.
I have been using PostgreSQL on Ubuntu for several years now.
PostgreSQL on Ubuntu is a stable solution.
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.
The deployment of PostgreSQL on Ubuntu was quite straightforward.
The deployment took approximately one day.
Only one person was involved in the process of deployment for PostgreSQL on Ubuntu.
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.
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.
