PostgreSQL

(194)
4.3 out of 5 stars

PostgreSQL is a powerful, open source object-relational database system.

Work for PostgreSQL?

Learning about PostgreSQL?

We can help you find the solution that fits you best.

Find the Right Product

PostgreSQL Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 196 PostgreSQL reviews
LinkedIn Connections
PostgreSQL review by <span>ALEXANDER J.</span>
ALEXANDER J.
Validated Reviewer
Verified Current User
Review Source

Excellent Database Manager

Updated On
Validated Reviewer
Verified Current User
What do you like best?

Database with excellent features to store data, integration with many applications developed in different languages ​​of application development, compatibility with Windows operating systems, Linux, etc. Ease of integration with ETL solutions, to store data warehouses to interact with business intelligence software, allows replication of data with streamig replication, the availability of operational continuity through the implementation of pgpool, binaries to perform backup and recovery processes , implementation of WAL, possibility of executing auto vacuum to keep the objects of the database clean, version updates of the postgresql SMBD, are easy and applications are not affected.

What do you dislike?

The postgresql database management system has a weakness that does not have high availability mechanisms, does not include cluster administration, only includes isolated tools for the implementation of continuity of service, and integrates a group of solutions to support postgresql as This is the case of pgpool

Recommendations to others considering the product

Before the implementation of postgregar in your infrastructure, make a test plan for the compatibility of the applications developed, perform a intonation postgresql of SMBD, so that the performance of the work is adjusted to the servers where it is installed. Implement a backup and backup plan, install a good software to monitor the performance of the database, I recommend NAGIOS as software for monitoring, from my own experience I recommend installing the postgresql SMBD under the Debian operating system, and verify the configuration files to customize the parameters for the best performance of the postgresql SMBD.

What business problems are you solving with the product? What benefits have you realized?

Reduce maintenance and licensing costs

0 of 0 found this helpful.
Helpful?
Sign in to G2 Crowd to see what your connections have to say about PostgreSQL
Headshots
PostgreSQL review by <span>John R.</span>
John R.
Validated Review
Verified Current User
Review Source
Validated Review
Verified Current User
What do you like best?

The developer community behind Postgres is phenomenal. Not only do they keep the software active, they give their time speaking and teaching about the software. The speed and reliability of the software is also great.

What do you dislike?

Postgres number one priority is data reliability, then speed, which causes some features like COUNT() to be slower than I'd like. While this is ideal 99% of the time, there is that 1% when I wish there was an option to configure the software to make COUNTs faster, even if it meant less reliability for that qeury's result.

Recommendations to others considering the product

Setup and configuration are not easy, but it's mostly system administrators and DBAs using it so that is to be expected. Admin tools, such as pg_basebackup, have improved.

What business problems are you solving with the product? What benefits have you realized?

Postgres powers our web based software, Intervals. It's been the best choice we could have possibly made for over 11 years since we first adopted it. We have benefited most from the speed improvements and replication features.

0 of 0 found this helpful.
Helpful?

What Relational Databases solution do you use?

Thanks for letting us know!
PostgreSQL review by <span>Ashish G.</span>
Ashish G.
Validated Review
Verified Current User
Review Source
Validated Review
Verified Current User
What do you like best?

PostgreSQL or simply Postgres implements the SQL standard very well. Postgres provides a easy to understand tool called pgAdmin to interact and manipulate database. It provides support for complex data types like Array and Json. It can handle workloads ranging from small web applications to large data warehousing with many concurrent users. It is available till 10,000 rows on Heroku.

What do you dislike?

PostgreSQL query syntax for some complex queries like array,string functions and case operator are is not easy to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as MySQL and it is bit harder to google search results.

Recommendations to others considering the product

I recommend PostgreSQL to all web application who are looking for cost effective database. It supports almost all types of backend server like, Java, Ruby, Python etc. Postgre SQL provides high level of parallel queries. It support very useful types like array and JSON.

What business problems are you solving with the product? What benefits have you realized?

From last one year we moved from MySQL to Postgres for database needs reason being of its support for multiple concurrent connections in affordable price. We are now using Postgres database for our new projects. I got benefit using PostgreSQL in term of price, speed, support of complex type and easy to learn query syntax.

0 of 0 found this helpful.
Helpful?
PostgreSQL review by <span>Ross M.</span>
Ross M.
Validated Reviewer
Verified Current User
Review Source

PostgreSQL - the heart of our GIS

Reviewed On
Validated Reviewer
Verified Current User
What do you like best?

PostgreSQL with PostGIS and pgRouting offers us a flexible, robust and reliable open source database platform on which to build the rest of our GIS infrastructure. The open source license gives us the freedom to install and use it as we like.

What do you dislike?

If I had my way I would switch out all our other RDBMS for PostgreSQL.

Recommendations to others considering the product

PostgreSQL offers a solid database platform on which to build applications for organisations not willing to pay large annual maintenance fees. It scales well from small single use applications to large clustered enterprise-wide systems. The open source license lets you install as many instances as you need for free. The open source, standards compliant database allows you complete flexibility in designing the database and any applications it underpins. PostGIS and pgRouting are database extensions that add greatly to the capabilities of the product and are core to our GIS infrastructure. Documentation for the product is second to none and the user community is excellent. If you so wish, support contracts are available from a number of suppliers in the UK and internationally. PostgreSQL is also available from many cloud service suppliers and runs on all major operating systems.

What business problems are you solving with the product? What benefits have you realized?

PostgreSQL replaced Oracle at the heart of our GIS infrastructure. We have saved money on software licenses, reskilled a number of people in database administration and reduced the number of files stored in directories to almost zero by putting the data in the database. The database is becoming the single source of truth for all spatial data in the organisation. The flexibility offered by the database has improved the efficiency of a number of different data creation and maintenance workflows and as a result we have grown the number of users from 10 to 75.

0 of 0 found this helpful.
Helpful?
PostgreSQL review by <span>Allison T.</span>
Allison T.
Validated Reviewer
Verified Current User
Review Source

Simple and easy to use

Reviewed On
Validated Reviewer
Verified Current User
What do you like best?

I like how simple this software is. It doesn't try to get you with a fancy UI or anything crazy intricate. it's straight forward and it is easy to use for anyone who has SQL experience. Whether in the classroom or at the workplace, it's a really great program for database work. It's user friendly in the sense that is is basic and easy. It may not have all the bells and whistles of other software but that's kind of what I like about it. The output pane when doing queries is nice and simple to read. it's easy to make sure you can see all of the data you need to see in your databases. I also like that the SQL editor gives you color differences on the words so you know that you are entering the correct information. It will come up red if it thinks something is wrong.

What do you dislike?

It's hard to tell sometimes which DB on your server you are in, as it doesn't highlight it very well. It also is somewhat annoying to have to open a separate screen for actually running SQL.

Recommendations to others considering the product

Learn up on SQL!

What business problems are you solving with the product? What benefits have you realized?

We are able to look up information quickly when a user needs to know about data that we can only find within the database. It's great for when we are looking into defects and also for writing automation tests. There are a lot of benefits.

0 of 0 found this helpful.
Helpful?
PostgreSQL review by User in Program Development
User in Program Development
Review Source

PostgreSQL review

Updated On
Validated Reviewer
Verified Current User
What do you like best?

Although the speed of response may seem deficient in small databases, that speed is maintained by increasing the size of the database, which is not the case with other programs, which slow down brutally.

Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs.

Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance.

Stability and Reliability: No database crashes.

Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs.

Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state.

Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups

Graphic design and database management tools.

It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL.

It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X.

Good security system through the management of users, groups of users and passwords.

Great storage capacity.

Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly.

What do you dislike?

Compared to MySQL it is slower in insertions and updates because it has intersection headers that does not have MySQL.

Online support: There are official forums, but there is no obligatory help.

Consume more resources than MySQL.

The syntax of some of your commands or statements is not at all intuitive.

Recommendations to others considering the product

YES

What business problems are you solving with the product? What benefits have you realized?

Multiversion concurrency control; the MVCC; this method adds an image of the state of the database to each transaction. This allows transactions to be made consistently, offering great performance advantages. For example, it is not necessary to use read locks when performing a transaction, which provides greater scalability. thus solving scalability problems.

0 of 0 found this helpful.
Helpful?
Kate avatar
Kate from G2 Crowd

Learning about PostgreSQL?

I can help.
* We monitor all PostgreSQL reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.