Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

PostgreSQL Reviews & Product Details - Page 60

PostgreSQL Overview

What is PostgreSQL?

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

PostgreSQL Details
Show LessShow More
Product Description

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


Seller

PostgreSQL

Description

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:
008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Overview Provided by:
CTO at Coronys LTD.

PostgreSQL Integrations

(3)
Integration information sourced from real user reviews.

Recent PostgreSQL Reviews

Biruk T.
BT
Biruk T.Mid-Market (51-1000 emp.)
5.0 out of 5
"Robust PostgreSQL support with enterprise grade features"
EDB provides a reliable PostgreSQL experience with extended enterprise tools like EDB Postgres Advanced Server. I specially appreciated the integra...
Verified User
U
Verified UserSmall-Business (50 or fewer emp.)
5.0 out of 5
"PostgreSQL:"
Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in J...
saif eddine m.
SM
saif eddine m.Enterprise (> 1000 emp.)
5.0 out of 5
"My Experience With PostgreSQL"
What i like most about PostgreSQL is the ergonomic interface , easy to understand .

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
View More Pricing Information

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Answer a few questions to help the PostgreSQL community
Have you used PostgreSQL before?
Yes

637 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
637 PostgreSQL Reviews
4.4 out of 5
637 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Jony C.
JC
DBA
Information Technology and Services
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Flexibility, fullness of features and easy extensibility.

for almost anything you might want there's usually an extension that provides this - if not, it's very easy to write your own.

other than that you have the basics fully covered, Loads of SQL features, fast performance, HA,...

Also, the lack of centralized data dictionary is greatly simplifying design for multi-tenancy applications as it allows for a straightforward approach.

Last but not least, postgresql as a product advances in an impressive rate, catering for more and more use cases and deployment options, with great emphasis on performance and data consistency.

It's exciting to see the product and community evolve - make a quick comparison between 9.2 & 9.5 and you'd be amazed what a couple of years can do. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's still behind some of the big players in terms of the optimizer - it lacks many smart optimizations which means that for really complex stuff, you are still better off with Oracle or SQL Server.

(then again remind yourself of the bill :) ) Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you're looking for an OLTP engine for a medium sized DB (100s of GB) you're in PGs sweet spot.

It's free and you'd hardly get any benefits from using commercial products here.

The community support is awesome and very responsive. (and you have plenty of companies doing payed support if needed) Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We use PostgreSQL as our main OLTP server - almost all of our on-line flows go through PG.

It's great for multi-tenancy, it allowed us to scale well while using a rather simple data structure.

(this in terms translates to a high DEV rate) Review collected by and hosted on G2.com.

Ramón L.
RL
Analista de Sistemas
Information Technology and Services
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgresql is an sql engine that supports a huge load of transactions and has a great community support, the documentation is wide and implementation is not as hard as some people claim, plus it's supported on most today cloud service providers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If one comes from mysql or sqlite, postgres can be a bit difficult, specially with the database and table specification, but this depends on the SO too so this can be a problem for some and not a problem for others. A lot of the old classic shared hosting providers still don't support postgres. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Learn the migration path if you come from other sql engines. Other than that. The documentation is enough for setting things up. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Storing Data is the main goal when you need a database. And postgres does that just right. Mysql falls when managin huge loads of data, but postgres has a nice optimization which allows for a larger data load, and this is the reason a lot of people migrate to pgsql. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is very robust, easy to use and has a nice documentation. It comes with a lot of built-in tools such as generating unique identifiers (UUID/GUID) and has many ready to use plugins such as PostGIS for geospatial querying. If your organization uses a relational database, then PostgreSQL is as good as it gets. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As with any SQL database, PostgreSQL has a lot of limitations. The biggest limitation that in my application is full-text search. To be fair, PostgreSQL does come with some nice tools for full-text search, but relational databases are not designed for this stuff and you're better off using a specialized tool like ElasticSearch, which happens to work pretty well with PostgreSQL. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Make sure that you're comfortable with SQL before using PostgreSQL. Also read the documentaion Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We use PostgreSQL to keep track of our customer and business records. Review collected by and hosted on G2.com.

Josh S.
JS
Senior Software Engineer
Marketing and Advertising
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Fast fetching large data. Able to store and somewhat able to search json blobs. Able to use inheritance in tables. Based on well known sql language. Lots of info in admin tables Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The size grows like crazy. After a db export/import it can shrink to 30% the size with the exact same DB which means lots of space was wasted. Tons of tables can be slow to vacuum and that can cause a DB crash. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Preferred over my experience with sql and nosql DB Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Storing masses of ads on search engine result pages.

It pulls back masses of data faster than we got with mysql Review collected by and hosted on G2.com.

Michael H.
MH
Senior Support Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgres has been an incredible open source tool for our company as we've grown. We switched from MySQL, which we quickly outgrew, and have been going strong on a Python+PostgreSQL build ever since. It's easy to get new DB users up and running on simple tasks, and has great flexibility with its user defined functions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

All the graphical query tools that are also free are mediocre at best. There are some really good ones, but they require a subscription. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Its open source, give it a shot, you won't regret it. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Proprietary and client data storage in an easily accessible form as well as powering our software interface by building out data tables on the back end. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I like that is very powerful and also free. It has a lot of interfaces for almost every programming language and lets you storage big objects, like pictures, videos and sound files. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't like the tool pgAdmin, that lets you manage your databases graphically. It doesn't work well, is really slow, doesn't have prediction when you are writing queries and also stops working without any reason.

Another thing that I don't like is that you have to use LIMIT x instead of TOP x to get some x quantity of rows Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Really give it a try. It is very powerful and easy to install and setup. Also it has a graphic tool that let you see how the data is storage in rows and columns Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I had to manage the databases of my university, so we move from MySQL to PostgreSQL because it was free, allowing the university save some money, but also it is very useful and potent database manager. Review collected by and hosted on G2.com.

JD
Freelance Web Developer, Specializing in PHP, PostgreSQL, and Django
Information Technology and Services
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Fast, extremely scalable, in active development, easy to learn and use, complies with SQL standards, and can handle large GIS data sets with PostGIS. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Upgrading minor versions is sometimes a pain with the PostGIS extension. We occasionally have to dump and reload the entire database to get things working without losing data. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I would recommend keeping separate data directories for each minor version. (E.g., 9.3, 9.4, 9.5). This makes upgrading the database much easier (and possible to rollback if something goes wrong). The old data directories can be deleted afterward. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

My company's product uses GIS data heavily. PostgreSQL (with the PostGIS extension) makes it a breeze to cut through large data sets. Recent versions have also allowed us to handle data warehousing using materialized views, which dramatically increases responsiveness to the user. Review collected by and hosted on G2.com.

Arthur F.
AF
Creative Technologist
Design
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

After years using other SQL database, I decided to give PostgreSQL a go.

It is amazing how easy it is to integrate to any solution. I've used PostgreSQL in many environments and I was always glad for choosing this database engine. In every language that I use to develop with Postgres there are built-in tools to make my life easier.

PostgreSQL also supports a huge amount of data types, including user defined types which makes the life of a developer way easier. I also feel that I need way less plugins or tools to develop with. It works perfectly out of the box and has a great performance.

Seeing great tools like Heroku adopting Postgres is amazing and just confirms that this is indeed a great tool.

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Coming from MySQL I miss the Admin tools. PostgreSQL has loads of tools that you can use to manage your database but none will top MySQL Workbench or even phpMyAdmin. Even trying clone tools like phpPgAdmin, it is just not the same. Working on big project without a great database design tool makes it a bit harder to adapt.

Postgres has great tools, but it still behind comparing to other solutions. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Get used by using the command line interface for PostgreSQL. GUI Tools for PostgreSQL are not the best and the earlier you start using the command line, you will see that you can do so much more work without loosing time drag and dropping and switching windows. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I changed to postgres mostly because of my job. After the first few days with it I realied that there was not turning back. PostgreSQL is fast, easy and works great out of the box. The integration with any project is just flawless. Review collected by and hosted on G2.com.

Edward F.
EF
Lead Scientist
Computer Software
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The features in PostgreSQL are excellent, other competing products are years behind in the tools that are already available. It is very configurable for almost any kind of environment and product you are building, if you need high availability, redundancy, clustering, etc. it is supported. Lots of granularity in the data being stored. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Coming from a product like MySQL that is much simpler than PostgreSQL can seem a little overwhelming as you get up to speed on documentation and configuration guides. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Get past the initial hurdle of learning how PostgreSQL works and enjoy using it - it offers a lot of great functionality. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Needing an open source and free database solution that was more reliable than MySQL but had most of the functionality that exists in Oracle. Our database is rock solid and performs very well, it's been easy to customize as our needs change. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It follows the syntax of standard SQL, quite closely related with MySQL, and it has wide variety of features not present in MySQL . . . . also is friendly with languages like Python and the likes. The existence also of a local database management software (pgAdmin) and command line tool makes everything much easier for first time users, and for experienced developers as well. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing so far, in particular. All in all it is a whole package as an SQL language. I have yet to delve deeper into back-end development and look further into what the PostgreSQL lacks as an SQL language. But so far it satisfied my basic needs in an SQL and back-end language. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

A must-use especially if you are a newbie in the field of back-end development. Very developer friendly and complete-packaged. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Database management through SQL with the whole package and features needed by a back-end developer. Review collected by and hosted on G2.com.