PostgreSQL

(206)
4.3 out of 5 stars

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

Work for PostgreSQL?
Informixenterpriseedition 2x

Learning about PostgreSQL?

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

PostgreSQL Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 208 PostgreSQL reviews
LinkedIn Connections
PostgreSQL review by <span>Maria L.</span>
Maria L.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

The definitive DB you need

What do you like best?

- Its free and open Source!

- Transactional support for schema migration,

- Large variety of custom functionality and plugin,

- Great overall performance - perfect for system with low hardware specs - it is light and well optimized

Huge community with a great support

What do you dislike?

- Backup and Restore of large DB are a bit slow, with some significant performance gap compared with other DB

- Not very User Friendly for new users or for those who are used to using paid software

- The absence of the possibility of the clustering is essential for us, and we must therefore rely on a third part software.

Recommendations to others considering the product

It's one of the best DB that you can find!

Its:Open source, have a huge and great community, new versions are released every six months (they are very stable too), it support JSON, XML and Geospatial

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

We doing Web-based product and we used it for storage and DB purpose. It is used by our entire organization and is well-integrated iwth our business process. With it we have reduced costs due to licensed sotfware, and speeded up the development in general. We find in PostgreSQL everything we need!

Sign in to G2 Crowd to see what your connections have to say about PostgreSQL
Headshots
PostgreSQL review by <span>ALEXANDER J.</span>
ALEXANDER J.
Validated Reviewer
Verified Current User
Organic
Reviewed On

Excellent Database Manager

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

What Relational Databases solution do you use?

Thanks for letting us know!
PostgreSQL review by <span>John R.</span>
John R.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

By far the most powerful and advanced open source database software

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.

PostgreSQL review by <span>Ashish G.</span>
Ashish G.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Open source object-relational database management system for Web Developers

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.

PostgreSQL review by <span>Ross M.</span>
Ross M.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

PostgreSQL - the heart of our GIS

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.

PostgreSQL review by <span>Allison T.</span>
Allison T.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Simple and easy to use

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.

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.