PostgreSQL Archived Reviews (More than two years old)

Filter by:Reset all filters
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Real User
Information Technology Technician at a tech vendor with 51-200 employees
Feb 14 2018

What is most valuable?

* Robust backup and recovery integration. * Follows ANSI SQL. * opensource * easy to integrate with applications and high level programming languages such as; python, ruby, java, C, perl, php...

How has it helped my organization?

We are considering migrating to this platform due to its robust backup and recovery solution, among many other features.

What needs improvement?

* Possibility to use query routers on sharded clusters. * Remove the limitations of how many changes one can have on the databases before it requires to reset all blocks, which are very painful.

What's my experience with pricing, setup cost, and licensing?

Use backup software that integrates with the solution. We selected "DB Protection for PostgreSQL", which has some nice features to perform block level incremental forever using IBM Spectrum Protect.

Which solution did I use previously and why did I switch?

We switch to this solution due to its stability and that it is open source.

Which other solutions did I evaluate?

Yes, we reviewed MongoDB, MariaDB, and MySQL.
Vendor
CTO at a tech vendor with 51-200 employees
Jul 30 2017

What is most valuable?

The new JSON data type that allows to use some NoSQL-like functionality. This is great because brings some of the most valuable features of NoSQL databases to relational databases. You can have a… more»

How has it helped my organization?

We use it as main database for our SaaS product.

What needs improvement?

Scalability; Although PostgreSQL is known for handling very well large amounts of workload, NoSQL databases performs better when scaling. NoSQL databases were built with scalability in mind, so it´s a… more»

Which solution did I use previously and why did I switch?

We had several performance issues with MySQL.

What other advice do I have?

Explore all the features.

Which other solutions did I evaluate?

Yes, MySQL.
Find out what your peers are saying about PostgreSQL, Firebird, EnterpriseDB and others in Open Source Databases. Updated: June 2020.
426,617 professionals have used our research since 2012.
Vendor
Expert Web Developer at a tech vendor with 501-1,000 employees
Jul 21 2017

What is most valuable?

It works great out-of-the-box and it opens up many opportunities in project development. I first install the regular version. I only configure complex things when they are needed.

What needs improvement?

I think that the product fully meets the needs of modern development. If there is something missing in it, then it is probably a too narrow profile function.

What's my experience with pricing, setup cost, and licensing?

As far as I know, there are no problems with the license for free use.

Which solution did I use previously and why did I switch?

I used MySQL. I switched because at that time, because some things were complicated with MySQL. For example: scaling, sparse data JSON, and other issues. Both projects have the same query syntax, and… more»

What other advice do I have?

I think this is the only decent solution for a relational database in web development.

Which other solutions did I evaluate?

I explored many different databases: Redis, MongoDB, MySQL, Elasticsearch, and others. I use some of them in conjunction with PostgreSQL. However, if we are talking about relational databases, then I… more»
Liliana Rodríguez
Real User
Analista Funcional Líder at a government with 5,001-10,000 employees
Jul 13 2017

What is most valuable?

PostgreSQL is an open source database, so there is no associated licensing cost for the software and we always have a new version easily available. It runs on all major operating systems, although I… more»

How has it helped my organization?

I have worked at the Ministry of Economy in the IT area, for more than 20 years ago. Since then, the main developments have always used PostgreSQL for their robustness, reliability, stability, and… more»

What needs improvement?

I have noticed that it consumes a lot of resources. I would improve this aspect.

What's my experience with pricing, setup cost, and licensing?

I recommend everyone to get into the PostgreSQL world, with no licensing costs. PostgreSQL uses a flexible and business-friendly license because it does not restrict the use of PostgreSQL with… more»

Which solution did I use previously and why did I switch?

I have used other solutions for over 20 years and the problem of licensing has been our biggest drawback because of the costs and dependence we require from the provider.

Which other solutions did I evaluate?

We got carried away by the experience of a team member with experience in PostgreSQL and first we used the tool in applications of low concurrency of users but with storage of files pdf, doc and xls… more»
Consultant
Founder and CEO at Shreeyansh Technologies | The Database Company
Mar 22 2017

What is most valuable?

* Integration with various programming languages * Partial indexes * Online backups/recovery * Replication * Hot standby * Cascading replication * Partitioning * Performance

How has it helped my organization?

This is an open-source product with advanced features that support OLTP/OLAP applications with the following benefits that helps organizations grow: * No recurring licensing cost * Huge cost savings forever * No vendor lock in * One-time… more»

What needs improvement?

The product has room for improvement with horizontal scalability and multi-master replication options, where community work is already in progress. These features will greatly benefit customers by balancing the load between servers… more»

What other advice do I have?

I strongly recommend this product, with no recurring licensing liabilities with community support and with optional commercial support available. Shreeyansh Technologies provides various quality database services in 24X7 model to support… more»

Which other solutions did I evaluate?

PostgreSQL is written in ANCI C, fulfilling all of the ACID properties other proprietary databases support. Most of the customers who use proprietary database solutions to their business applications prefer to move away from proprietary… more»
Danilo Martins
Real User
Developer at a comms service provider with 51-200 employees
Mar 22 2017

What is most valuable?

* Free and open-source RDBMS, with a permissive license * ACID compliance * Multi-version concurrency control * Custom data types * Array data types * PL/Python stored procedures

How has it helped my organization?

Back in the day, MySQL had storage problems with InnoDB (everything in a single file), and we wanted ACID compliance. So we decided to use PostgreSQL for that, and it helped us achieve that goal. PostgreSQL's feature set was excellent for… more»

What needs improvement?

There's always room for improvement. Better SELECT performance is something that PostgreSQL could really benefit from. Replication should also be made easier. PostgreSQL also lacks a good tool like MySQL Workbench. PgAdmin3 works, but it's… more»

Which solution did I use previously and why did I switch?

Up to that point, we used MySQL. The decision to change came with a new version being written from scratch, and PostgreSQL being better suited for our needs.

What other advice do I have?

PostgreSQL has extensive and comprehensive documentation. Chances are that you'll find your answers there for 99% of the cases. For those answers you don't find, you can always go to StackOverflow. If you're not a DBA or a programmer, I'd… more»
Vendor
Senior Database Engineer at a consumer goods company with 1,001-5,000 employees
Oct 26 2016

What is most valuable?

The reliability, performance, and extensive list of features are what I think matter the most in a production environment.

How has it helped my organization?

I have never been in an environment where PostgreSQL was not used. It was always used alongside other RDBMS solutions, depending on the specific requirements of each project. In this way, we were… more»

What needs improvement?

There are still things missing compared to other RDBMS, for example monitoring is a little behind as there not that many solutions out there. An equivalent of Oracle's RAC and/or flashback logs would… more»

What's my experience with pricing, setup cost, and licensing?

I am working with other databases, and not exclusively with PostgreSQL. A lot of other RDBMS require you to pay large amounts of money so I would say that you need to carefully plan your projects… more»

What other advice do I have?

There are some features missing compared to other RDBMS. The community is always expanding and more and more people use PostgreSQL every day. There are many forums where you can get information from… more»

Which other solutions did I evaluate?

I have tried and worked on other solutions such as Oracle and MySQL. I would say that the combination of PostgreSQL's features, plus the reliability and performance it offers in combination with the… more»
Consultant
Consultant at a tech consulting company
Oct 25 2016

What is most valuable?

Strong enforcement of data types, because it can catch many errors and mistakes and protects data. Standard conformance, because in the end you are not locked to single vendor.

How has it helped my organization?

We used MySQL for many tasks, because there were simply more documentation available, but while using it, we found many serious weaknesses with it like no data validation even for string length, no transactions, etc. PostgreSQL catches a… more»

What needs improvement?

It needs more parallelism for big tables. This is already in PostgreSQL 9.6 beta so things are looking promising.

Which solution did I use previously and why did I switch?

We previously used MySQL. PostgreSQL tries to solve things in the correct way for all platforms, all file systems, and all users. In the end, this means you get a better working and more stable system. They try to stay away from hacks and… more»

What other advice do I have?

Explore this new world. PostgreSQL has taken a quantum leap over the last 20 years, and now it seriously threatens more established database vendors.
Consultant
BI Expert at a consultancy with 501-1,000 employees
Oct 13 2016

What is most valuable?

GIS function. Geography is a very important function/dimension for our f. Postgres helps analyse that easily.

How has it helped my organization?

It provides access to data for analytics. It has a lot of free tools available for data access, and has easy integration with a lot of visualization tools such as QlikView and Tableau.

What needs improvement?

They need to develop an easy way to do a cross-DB query and some basic report visuals and alert systems would make it awesome, if they are possible.

What's my experience with pricing, setup cost, and licensing?

It's free as it's open source.

What other advice do I have?

Go ahead with the product which has the best use case for your organization. Cost is never an issue.

Which other solutions did I evaluate?

For me all SQL tools/products are similar, except for a few important differences like GIS functions in PostgreSQL, and programming abilities in Oracle PL/SQL, etc.
Vendor
Front-End Developer at a financial services firm with 501-1,000 employees
Sep 24 2016

What is most valuable?

PostgreSQL provides a lot of valuable documentation and there's widespread usage of it.

How has it helped my organization?

I use it for personal projects. It's been really easy to learn and it's been useful since ramping up it use.

What needs improvement?

Although there's documentation out there, it needs even better documentation. Another thing that would be helpful are examples of usage of it with JavaScript.

What other advice do I have?

Compare and contrast various database optimizations based on your needs. And when you come across issues, don't reinvent the wheel -- someone has probably had a similar problem to your own.
Vendor
Director of Operations / Senior Software Engineer at a software R&D company with 51-200 employees
Sep 06 2016

What is most valuable?

PostgreSQL does a great job with scalability and performance. Since we are using Django/Python – it works great with PostgreSQL as well. The current features that really help us are Full-Text Search… more»

How has it helped my organization?

By using PostgreSQL, it was easy to get all the developers configured and running. With using it as our back-end for data storage, our company isn’t worried about data loss or data integrity… more»

What needs improvement?

The only thing I would really want/need to improve is pgAdmin3. pgAdmin3 is a nice tool for SQL Admin and Queries. But, I wish it would allow multiple queries to be run and displayed in the output… more»

What's my experience with pricing, setup cost, and licensing?

Pricing/licensing is the reason we went with PostgreSQL. As a startup, every dollar counts and PostgreSQL has enabled to us to have an enterprise solution at a fraction of the cost of Oracle and… more»

Which solution did I use previously and why did I switch?

We had used Microsoft SQL Server in our previous company. But, the licensing terms kept getting more and more onerous. We started looking at PostgreSQL from the reviews and recommendations, especially… more»

What other advice do I have?

PostgreSQL is an amazing product. Very easy to implement and there are many libraries to make it easy to use PostgreSQL as a back-end database solution, no matter what coding language you are using.
Consultant
Big Data Consultant at a tech services company with 1,001-5,000 employees
Aug 30 2016

What is most valuable?

I have not used any enterprise PostgreSQL product. I have only used the open-source version of PostgreSQL. I like the following features: * Locking: Tables very rarely get locked, while with MySQL, it’s a frequent problem. * Easy backup and restore * Reporting uses Windows functions / aggregates… more»

How has it helped my organization?

By implementing PostgreSQL, organizational databases get stabilized, no locking issues occur and report extraction is faster.

What needs improvement?

I would to see the following improvements: * Replication: Table-level replication should be built-in. However, we can do this now by using Slony. * Backup: Currently, an incremental backup feature is not available. It should be added. * A simple-to-use PG cluster monitoring dashboard would provide… more»

What other advice do I have?

So far, it’s the best database I have ever used.
Vendor
Chief Data Architect at a tech company with 51-200 employees
Aug 30 2016

What is most valuable?

The features we use most often are: * PostgreSQL streaming replication * PITR-based backups * CTE SQL * SQL windowing functions

What needs improvement?

I'd like to see the following improvements: * Streaming replication (or similar) disconnected from the version, so we can use it for upgrades (i.e., a 9.3 version master and a 9.5 slave) * Better scaling options such as sharding tools, parallel query and star schema-aware queries * Better partitioning support to include better / packaged partition management and the ability for the base table to… more»

What other advice do I have?

Get some expert help; I cannot stress this enough. We often walk into DB setups and architectures that are a wreck because the team "knew enough to be dangerous". Even more often, we see database isolation, meaning the DB is not connected to the enterprise data architecture. That mistake leads to expensive problems down the road. It's an open-source, license-free product that can go head to head… more»
Consultant
CEO at a tech services company with 51-200 employees
Sep 01 2016

What is most valuable?

* Replication which enables us to use it for High Availability. * The Foreign Data Wrapper means we can integrate it, and provide interoperability with other databases. * Multi-master Replication helps us to distribute a database geographically without any hassle or performing maintenance for… more»

How has it helped my organization?

Before using PostgreSQL, we had a database issue that we were trying to solve with Oracle. However, Oracle is quite expensive and I heard from a colleague that Oracle increases their charges year on year.

What needs improvement?

There are many places that it could be improved through the provision of more plug-ins and extensions, such as data distribution, load balancing, new data types, indexing and searching, etc. They could also make it easier to access data manually. PostgreSQL is Open Source Project, it is never ending… more»

What other advice do I have?

I would recommend PostgreSQL to anyone who wants to save costs and deploy a reliable enterprise class database server.
Vendor
Data Architect at Blue Treble Solutions
Aug 28 2016

What is most valuable?

In my experience, the data quality and extensibility are valuable.

How has it helped my organization?

I'm a data consultant that specializes in PostgreSQL. The combination of it's open community, open source approach and it's unique features make it the perfect platform for solving today's sophisticated data challenges.

What needs improvement?

Extensibility could be even better as there are still too many things that require programming in C to add to the database. There could also be better object-oriented support. The table inheritance feature is critical to some of my work… more»

What other advice do I have?

Always hire an expert to advise you on production database deployment. Similar to security, mistakes in this area have the potential to seriously impact your business. Postgres is free, but it can be difficult to hire experienced PostgreSQL… more»

Which other solutions did I evaluate?

I've used Oracle, DB2, Sybase and MSSQL. The only one that comes close to PostgreSQL is Oracle, and only because of the large set of developer tools it offers. But, it's very difficult to manage and extremely expensive.
Vendor
Sr. Database Engineer at a non-tech company with 5,001-10,000 employees
Aug 28 2016

What is most valuable?

Twice now, I have been involved in the decision by a company to migrate away from MS SQL Server to Postgres. The first time, it was simply a matter of scalability. Once you approach 10 TB of data, managing it in MSSQL becomes problematic… more»

How has it helped my organization?

One of the key ways that Postgres has improved the functioning of our organization is by freeing up financial resources that can then be applied to upgrading existing infrastructure. A side benefit, of course, is that by bringing in another… more»

What needs improvement?

I would really like to see a more mainstream approach to support what we see as critical extensions. One example is the FDW (foreign data wrapper) for MSSQL. This extension hasn’t been updated in several releases and would benefit from an… more»

Which solution did I use previously and why did I switch?

See my answer above. We evaluated both open-source as well as proprietary solutions. Of the open-source solutions we examined, Postgres has the best track record for innovation and enhancements. While the user base is smaller than some of… more»

What other advice do I have?

If you can, do it!
Vendor
Senior DB Engineer at a university with 1,001-5,000 employees
Aug 28 2016

What is most valuable?

For this question I will focus on our usage of PostgreSQL in the company. A great differentiator for this database, if compared with other providers, is its easy extensibility and the existence of… more»

How has it helped my organization?

The company I work for creates economic time series and forecasting’s based on monthly surveys with companies. Besides a set of general questions, different sectors of economic activity include… more»

What needs improvement?

v9.5, which we currently don't have in our productive systems, already has some key features that we would like to use. In particular, row level security, a feature allowing to restrict the visibility… more»

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is a community product and has no owner other than the community itself. There are companies specialized in offering services and add-ons on top of PostgreSQL, but the database software… more»

Which solution did I use previously and why did I switch?

We used Sentinel which was awesome but it did not provide metric views.

What other advice do I have?

Besides the simple fact of being an open product that can be used at virtually no cost, the quality of the code base is extremely good. The development process is transparent and the documentation is… more»
Vendor
Sr. Oracle and PostgreSQL DBA at a consumer goods company with 1,001-5,000 employees
Aug 28 2016

What is most valuable?

Open source products represent no cost to the organization and the basic features are sufficient to fulfill our needs.

How has it helped my organization?

* Cost savings * Easy spin off for new environments

What needs improvement?

The only feature where I can see an area of improvement is with the partitioning. As soon as you implement partitioning, all your relationships are no longer supported since the PK-FK relationship is… more»

What's my experience with pricing, setup cost, and licensing?

We use the open source versions of PostgreSQL so there is no expense for licensing.

Which solution did I use previously and why did I switch?

We haven't used any other open-source service, but we have engaged Enterprise DB for enhancing our monitoring but there was no need to do so.

What other advice do I have?

Do continuous testing and research on new features as they have an excellence performance response.
Consultant
PostgreSQL Database Administrator at a tech services company with 51-200 employees
Aug 28 2016

What is most valuable?

In my experience, the most valuable features of PostgreSQL are streaming replication, rich indexes support, extensibility and NoSQL features such as hstore and JSONB. This features are very mature and stable, we use them in many projects, they're predictable, always work as expected and without… more»

What needs improvement?

In future releases I would like to see built-in realization of multi-master cluster with sharding, effective partitioning, incremental backup, optimizations for SSD, connection pool facilities, and built-in replication for tables and databases.

Which solution did I use previously and why did I switch?

I don't use any similar solutions such as Microsoft SQL, Oracle, or MySQL.

What other advice do I have?

PostgreSQL is an amazing product, very stable, predictable and reliable with rich set of features.
Vendor
Senior PostgreSQL Database Adminstrator at a financial services firm with 51-200 employees
Aug 28 2016

What is most valuable?

This database is highly reliable and offers excellent disaster recovery. In short, I can depend on it to be available and operational.

How has it helped my organization?

As we’ve used this since our founding, I cannot speak to how it has improved any function.

What needs improvement?

The development team has been teasing me with talk of multi-master capability for some time. Their latest release, 9.5.3, does offer some asynchronous capability, but I really want synchronous… more»

What's my experience with pricing, setup cost, and licensing?

Obviously pricing and licensing is non-existent, but the costs need to include the expense of in-house expertise, either employees or consultants.

Which solution did I use previously and why did I switch?

I have used MySQL, another open source product now controlled by Oracle. It’s reasonably fast and OK for simple databases, but it lacks transactional isolation and its replication setup does not… more»

What other advice do I have?

PostgreSQL is an enterprise capable database very similar to many commercial offerings, but be prepared to either pay for consulting or a long period or experimentation to get the configuration… more»
Vendor
Co-Founder, CTO at a software R&D company with 51-200 employees
Aug 28 2016

What is most valuable?

Stability, compound & functional indexing, MVCC, transactional DDL, GIS extensions, recursive queries, common table expressions, materialized views, procedural languages, triggers, and excellent… more»

How has it helped my organization?

Full ACID compliance for all transactions (including those with DDL changes) is supremely helpful when making modifications to the schema. The query planner and indexing functionality is second to… more»

What needs improvement?

I would like to see the ability to reorder columns on a relation, as well as change the base SQL query that generates a materialized view without having to drop the view, provided the view's structure… more»

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is completely free and fully open-source.

Which solution did I use previously and why did I switch?

I've also used MySQL and MongoDB, but neither of those technologies provide any competitive advantage over PostgreSQL in any respect that comes to mind.

What other advice do I have?

PostgreSQL is the world's most advanced and performant SQL database available. It essentially beats out MySQL, Oracle, SQL Server, and often MongoDB on virtually every use case.
Consultant
Senior Database DevOps Engineer at a tech services company with 1,001-5,000 employees
Aug 28 2016

What is most valuable?

PostgreSQL is probably the most SQL-standard-compliant RDBMS on the market. It also goes way beyond standard relational paradigm combining key-value stores, arrays, and columnar stores into a single engine. With the introduction of Foreign… more»

How has it helped my organization?

PostgreSQL allows us to have a single database engine used for OLTP and OLAP workloads, for relational and non-relational data. Its robust and battlefield-proven replication makes us sleep better.

What needs improvement?

Logical replication would be a major improvement and it's already being worked on. It'll enable true multi-master replication and active-active setups. More OLAP-related performance improvements are also on the way with parallel query… more»

What other advice do I have?

Get a dedicated, PostgreSQL-focused resource, it's hard to convert DBAs with background in other denominations.

Which other solutions did I evaluate?

I work with few other RDBMSs, but nothing compares to PostgreSQL when it comes to ACID and SQL compliance, stability and the ease of administration.
Vendor
Technology Architect at Broadridge Financial Solutions
Jul 31 2016

What do you think of PostgreSQL?

Valuable Features:

The graphical query plan analyzer in pgAdmin III tool is a very valuable feature. Fast bulk data load and extract feature using COPY is a very useful feature I have used.

Improvements to My Organization:

Helped solve my problem to extract large amount of data in a specific order on a Greenplum application.

Room for Improvement:

String manipulation functions can be improved. I could not find reverse string function and ended up writing my own. Similarly array functions like length of array etc where not available and we created our own.

Use of Solution:

I've used it for 4 years now.
Vendor
Partner - PostgreSQL support manager at a tech company with 51-200 employees
Jul 25 2016

What is most valuable?

PostgreSQL provides the perfect combination of freedom, reliability, stability, security, performance, power, and ease of use. Freedom because it is the only world-class RDBMS not owned by a company… more»

How has it helped my organization?

We have migrated some databases from Oracle to PostgreSQL lowering licensing fees and reducing the vendor lock-in, gaining sovereignty.

What needs improvement?

The are many items in my wish list - parallel access (in development), incremental backups, standard MERGE statement (there is a similar INSERT/ON CONFLICT DO), snapshot queries (SELECT AS OF… more»

What's my experience with pricing, setup cost, and licensing?

There is no pricing/licensing at all. Of course, there are many companies offering PostgreSQL support at different costs and some specialized in several languages/countries.

Which solution did I use previously and why did I switch?

I have more than 10 years of DBA experience, working with Oracle, DB2 and MySQL too. All of them have pluses and minuses, and I usually need to explain that nobody can claim "X is better to Y", at… more»

What other advice do I have?

Ask the community. I believe any committed PostgreSQL user will be happy to help and provide advice.
Vendor
Developer Advocate (PaaS Dust Spreader) at a tech vendor with 5,001-10,000 employees
Jun 07 2016

What is most valuable?

The spatial extension, PostGIS, is amazing and probably the gold standard. I also like the Key-Value column type and the JSON column type. Apart from this, it has all the other features you will need in an RDBMS and then some. It has a vibrant FOSS community with a great license and it has plenty of… more»

How has it helped my organization?

Rather than using Desktop GIS software we were able to carry out a lot of our spatial operations faster with larger datasets by moving the operations into PostgreSQL. We also save a ton of money on Oracle licenses. Finally, rather than having to give up my relational features, I can use the JSON… more»

What needs improvement?

They need to work towards making it work better in a cloud environment. Also, I would love to see them developm multi-master replication.

What other advice do I have?

Get a good book so you can get exposed to all the great functionality in PostgreSQL. I would highly recommend looking at the postgresql.conf configuration settings when you are ready to go into production.
Consultant
Founder and Business Intelligence Consultant at Know Solutions
Jun 07 2016

What is most valuable?

It is easy grow it from a small environment to a large one.

How has it helped my organization?

We use PostgreSQL as the basic tool for offering our data warehouse and BI solutions. This way my customers have a free tool and I can offer a lower price for our services.

What needs improvement?

It should have a better native client tool to manage the databases.

What's my experience with pricing, setup cost, and licensing?

My advice is to always begin with the free licenses, and if you see that your tool is becoming a strategic solution, you can look into obtaining professional licenses.

Which solution did I use previously and why did I switch?

We had some problems with bigger customers using MySQL so we moved to PostgreSQL.
Consultant
Software Architect and Senior Technology Consultant at a tech services company with 51-200 employees
Jun 07 2016

What is most valuable?

PostgreSQL is a stable RDBMS. It's free, and supports standard SQL.

How has it helped my organization?

I have developed many portals and internet commercial sites with this RDBMS. It's easy and quick to publish portals and websites when you have this in production.

What needs improvement?

I believe that drivers must be better. For example, the .NET drivers could be more robust for the latest Entity Framework version.

What's my experience with pricing, setup cost, and licensing?

My only cost is for the server that PostgreSQL is hosted on.

What other advice do I have?

It is a good free RDBMS. It's stable, scalable and reliable.

Which other solutions did I evaluate?

I've worked with MySQL, Firebird, etc. and, in my opinion, PostgreSQL is more scalable.
Vendor
Platform Developer at a tech vendor with 51-200 employees
Jun 07 2016

What is most valuable?

Overall it is an excellent RDBMS and it is easy to use and administer. In PostgreSQL 9.5 the table inherent Foreign Data Wrappers(FDW) is available. This extension is available for most databases which makes building server federation very possible. In 9.5 support for FDW was improved which means it… more»

How has it helped my organization?

We were able to use the latest features described above to facilitate the integration of disperate data sources into our Postgres Data Warehouse.

What needs improvement?

* Improved support for parallel query execution * Merge Joins * Improved Handling of Materialized Views

What other advice do I have?

The last few versions work great out of the box without much config changes. Don't be afraid to try it.
Consultant
Senior Developer at a tech services company with 1,001-5,000 employees
Jun 07 2016

What is most valuable?

* Hassle-free, low maintenance operation * Free * SQL compliance * Slot-based streaming replication - live and purposely delayed are available * Robustness * Performance * Low maintenance * Decent Windows management GUI * Cross-platform

How has it helped my organization?

It's improved security by allowing us to switch from an unsecure file-based database to a secure SQL database without license payments. Also, it provides us with multiple disaster recovery options with streaming replication.

What needs improvement?

It requires better management tools.

What other advice do I have?

Well worth the effort! I've been using it in my professional capacity without a single incident.
Vendor
Specialist of Information Security at a transportation company with 1,001-5,000 employees
May 31 2016

What is most valuable?

I had many problems on v8.3 when I needed to use SSL client certificate authentication but on version 8.4 my problem was resolved, I’m an information security specialist and my focus is it so all features about security for me is important… more»

How has it helped my organization?

I can say that PostgreSQL increased the database possibilities within the company.

What needs improvement?

I have a dream that a database could import data safely and securely from other databases without errors and by using a GUI to help migrate the data.

Which solution did I use previously and why did I switch?

In my last company, we had been using Access. We changed to PostgreSQL as we needed something more robust and usable. This was provided by PostgreSQL which at the time was the perfect solution for what we needed.

What other advice do I have?

PostgreSQL is a perfect database to be used by small to mid-sized companies. Many years ago when I worked with medium companies I would have given it a 10/10 but as the database community has grown, it has decreased.
Consultant
Senior Software Engineer at a tech services company with 1,001-5,000 employees
May 31 2016

What is most valuable?

It allows people to use whatever multiple procedural language they are trained in, such as Java, Python, Pearl, or C and it is not limited to PL/SQL or PGSQL. Also, I love the PostGIS extension and I do not know of any other product like this.

How has it helped my organization?

I can integrate solutions quicker than with other RDBMS'. At the same time, I am able to keep an RDBMS' integrity, robustness, and High Availability which is the most important thing for all my production environments.

What needs improvement?

It is lacking some GUI admin tools and it would be nice if more could be developed by the community.

What other advice do I have?

It's the best in my opinion because have now found what I need to enable me to quickly deploy into my production environment. Go to a professional and ask for your needs, maybe you will surprise with a variety of solutions that you never thought existed.
Consultant
Software Engineer at a tech services company with 51-200 employees
May 31 2016

What is most valuable?

* Very good indexing solutions, especially for arrays and text search on large quantities. * Very good behavior on large databases (>800GB) and large tables. * Datatypes - support for vectors, XML, JSON, UUID and the functions and operators for them are very useful. * Programming languages - I… more»

How has it helped my organization?

All of our BI needs are implemented using PostgreSQL functions. Our tools are designed in such a way that the BI is implemented as much as possible through our database. We need a lot of flexibility to extend the BI logic on a specific installation.

What needs improvement?

Synchronous replication is needed, and although I have only searched the web for a couple of hours the only solutions I could find were at the application level of the database. XML and JSON manipulation functions need to be improved as for some applications we need to add new elements to these… more»

What other advice do I have?

Try it out! Sometimes, due to the high degree of configurability and extensibility, you might see some issues arise, but it's not that difficult to figure out what's happening. You will definitely be amazed by the SQL features and extensibility.
Vendor
Senior Application Programmer/Analyst, Team Lead at a university with 10,001+ employees
May 23 2016

What is most valuable?

PostgreSQL has excellent support for many programming languages. We've been able to integrate it with Java, PHP, Perl and .NET without any issues. Replication is also working pretty good in a master to read only replica setup in AWS.

How has it helped my organization?

We've been able to cut costs on databases over our previous solution with Microsoft SQL Server and migrate many applications into Amazon web services. Performance has been decent.

What needs improvement?

By far the biggest limitations are in replication support. A native master to master replication option would make things much easier as we're in need of an easier method to load balance traffic with Spring Data. PostgreSQL is slower than MySQL with insert performance. While using COPY can make an… more»

Which solution did I use previously and why did I switch?

Initially applications at my current employer used Microsoft SQL Server. The cost for licensing/maintaining windows systems was more than we liked. PostgreSQL has offered similar performance for our workloads with lower cost.
Vendor
DBA / ETL Developer / Consultant at a marketing services firm with 1,001-5,000 employees
May 23 2016

What do you think of PostgreSQL?

Valuable Features

It has the same features as paid-for databases such as Oracle and SyBase.

Improvements to My Organization

It's saved us money as it's free.

Room for Improvement

Eliminate the transaction wraparound possibility. If transaction wraparound occurs it can be a major problem.

Use of Solution

I've used it for two years.

Deployment Issues

There were no issues deploying it for us.

Stability Issues

We've experienced no issues with performance.

Scalability Issues

There have been no issues scaling it for our needs.

Customer Service and Technical Support

There is none available as it's a community driven solution.

Initial Setup

It's simple to get it up and running.

Implementation Team

We did it in-house.

Other Solutions Considered

We tested a…
Consultant
CEO - Software Engineer at a tech services company with 51-200 employees
May 15 2016

What do you think of PostgreSQL?

How has it helped my organization?

It has allowed us to run a Scada database, which reads data every 2 minutes. It does it in a very smooth way.

What needs improvement?

I would like to have better support for real-time applications.

For how long have I used the solution?

I've been using it for three years.

What was my experience with deployment of the solution?

No at the time. Our application fits very well.

What do I think about the stability of the solution?

No at the time. Our application fits very well.

What do I think about the scalability of the solution?

No at the time. Our application fits very well.

How are customer service and technical support?

I have used online free help.

Which solution did I use previously and why did I switch?

MySQL but not in…
Vendor
Chief Data Officer at a university with 5,001-10,000 employees
May 15 2016

What do you think of PostgreSQL?

Valuable Features

There are many valuable features, but the most valuable to me are Windows functions, Python scripting, and the fact it has a good PGSQL language.

Improvements to My Organization

It provides standardization on the database and related skills.

Room for Improvement

Parallelization and some connection to analytics is needed.

Deployment Issues

We had no deployment issues.

Stability Issues

The product is quite stable.

Scalability Issues

It has the ability to scale up into products like Redshift.

Customer Service and Technical Support

The online manual is superb.

Implementation Team

It's very easy, and you only need to familiarize yourself with its file structure. Sometimes you need to write your own plugin, so sometimes it is better to have it…
Vendor
Senior Developer with 501-1,000 employees
May 15 2016

What is most valuable?

PostGres is a fantastic modern RDBMS and its open nature allows you to get as low level as you need. You can define functionality, you can call from SQL and dig deep into the query planner with it's… more»

How has it helped my organization?

It drives our enterprise architecture we are building.

What needs improvement?

The only thing that could potentially be improved is PGAdmin3, the DB Client that's has not been updated in quite a while. PostGres keeps ahead of the curve on it's feature set. For instance the new… more»

What's my experience with pricing, setup cost, and licensing?

It's free as it's open source.

Which solution did I use previously and why did I switch?

I started with this product.

What other advice do I have?

It's go good reliability and is very compliant with standards. If you are installing relational DB you likely know how to use one. If you're not familiar with RDBMS's make sure you look into and use… more»
Vendor
Software Engineer at a tech vendor with 11-50 employees
May 02 2016

What is most valuable?

* Stability * Standard SQL for ease of development with pre-existing knowledge

How has it helped my organization?

Postgres is for our systems a very solid database, easy to use in development and easy also to manage in production environment, and that's valuable because in the end it cuts a lot of costs (also during the upgrading processes).

What needs improvement?

The Postgres team is already doing an amazing job in putting in features to ease the life of developers and sys admins, such as JSON support and database replication. A feature that is still a work in progress and it would be nice to have… more»

Which solution did I use previously and why did I switch?

I used MySQL and Oracle previously, PostgreSQL is open source and fully ACID and SQL standard

What other advice do I have?

It's a great database engine that is easy to use, powerful, and scalable.
Consultant
TIBCO Middleware Architect & System Administrator at a tech services company with 1,001-5,000 employees
May 02 2016

What is most valuable?

JSON support, especially the new JSONB data type is valuable . We used to have a mix of PostgreSQL and MongoDB to solve some of the complex problem around data schemas, now, we rely solely on PostgreSQL as our main datastore. Same… more»

How has it helped my organization?

PostgreSQL has been a key component of our business, it is a rock solid product with years of expertise behind it, it is more cost-effective than Oracle and allows us to focus on innovation rather than licensing costs.

What needs improvement?

JSON support although great, it still has some gotchas, querying and manipulating JSON will be one of the topics I'd like to see some improvement, still feels not natural to work with it.

What other advice do I have?

PostgreSQL is a great product, very mature and is evolving into other areas beyond SQL, in this times of connected devices and big data analytics, PostgreSQL can still be considered one of the key components and works very well with others… more»

Which other solutions did I evaluate?

We evaluated Oracle, MongoDB and CouchBase. Although those seem to be different products, they have some common features that worked for us, we decided to go with PostgreSQL because of its reliability and proven track record.
Vendor
Sr. Database Architect at a tech vendor with 501-1,000 employees
May 01 2016

What is most valuable?

PostgreSQL is the only open source and multi-functional database solution out in the market today. I have used it to replace Oracle (RDBMS) up to MongoDB (Document DB). Postgres has very rich SQL and… more»

How has it helped my organization?

PostgreSQL is the most flexible database I have worked in my career. For example, when I need geographical data processing for my application, I can use PostGIS. It is the best GIS solution out in the… more»

What needs improvement?

PostgreSQL has introduced number of new features to achieve out of the box multi-master replication and reach JSONB features, horizontal and vertical scalability and parallelization features. I’d like… more»

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is truly open source database system so the licensing cost is zero. If you are migrating from any commercial database system, you are saving licensing and recurring support costs.

Which solution did I use previously and why did I switch?

I used to be an Oracle DBA over decade ago. I have used over dozen of database solutions ranging from MySQL to MongoDB in the distributed production environments but Postgres provides superior… more»

What other advice do I have?

If you don’t have experience with PostgreSQL, I recommend to attend some of the local PostgreSQL user group meetups and/or conferences to learn how it is being used. If you need help discussing about… more»
Vendor
Staff System Admin at a tech company with 5,001-10,000 employees
May 01 2016

What do you think of PostgreSQL?

What is most valuable?

From our use of it, its stability and performance are the best features. The fact that there's no downtime and that it functions quickly are very important to our workflow and business.

How has it helped my organization?

We're in the evaluation period at my current company, so we haven't really seen improvement to our functioning.

What needs improvement?

The multi-master replication feature needs improvement.

For how long have I used the solution?

I've used it for eight years now.

What was my experience with deployment of the solution?

We've had issues with deployment, but I can't share the details.

What do I think about the stability of the solution?

We've had issues with stability, but I can't share the details.

What do I think about the

Consultant
Senior Software Engineer, Technical Lead at a tech services company with 51-200 employees
Apr 30 2016

What is most valuable?

PostgreSQL, especially the latest versions, comes with a very rich set of server side programming tools, while providing speed, data consistency and the transaction's coherence. This is a very wide… more»

How has it helped my organization?

I have a quick example about how it reduced the amount of backend code and also improved the application's performance. When you are in a scenario where your application has an input, and based on… more»

What needs improvement?

Starting with v9 it can be seen an intensive activity to bring more features, more performance or productivity. I would like to see it be more reliable, and easier if possible, to make PostgreSQL… more»

What's my experience with pricing, setup cost, and licensing?

The investment was in proper hardware and learning curve to master the database. Charging for expertise to deploy PostgreSQL depends on the expected setup, but in all cases, my choice would be to… more»

Which solution did I use previously and why did I switch?

I've used a larger set of databases (including the most well-known and a few more exotic) and setups. Definitively PostgreSQL is a serious contender at the top of the list. I chose it because it's… more»

What other advice do I have?

This is a very good product, and I'm very pleased, especially with the latest versions. I haven't found the perfect database yet, but definitively PostgreSQL is a candidate to consider, especially if… more»
Vendor
Digital Development Engineer at a comms service provider with 1,001-5,000 employees
Apr 30 2016

What is most valuable?

* It's open source product not need to license, so economic * It provides a graphical interface (pgAdmin) simple, intuitive and efficient * Simple installation * It does not consume a lot of resources * Really suitable for business n-tier solutions * Rich documentation * An interactive community

How has it helped my organization?

The strength of this product is set in the timeliness of SELECT queries with lots of joins. compared with other DBMS, it is really optimized for joins.

What needs improvement?

I think that due to the lack of functionality for data warehousing, it is more suitable for operational information systems instead of BI systems. Besides, it only allows Relational Online Analytical Processing (ROLAP) not Multidimensional Online Analytical Processing (MOLAP).

What other advice do I have?

Because we use it in many information systems (Financial, Human Resources, Inventory Management) in several large companies with significant data flow, we have not had problems. It was effective as a product. Read the product documentation well and know the configuration parameters because just one… more»
Vendor
Computer Science Teacher at a K-12 educational company or school with 501-1,000 employees
Apr 30 2016

What is most valuable?

* Confidentiality * Integrity * Availability * Bug free I like to work with a piece of software that is bug free and doesn't required to be launched in order that users will find a couple of bugs in the coming weeks and that the company has… more»

How has it helped my organization?

It helped me to find an easy and inexpensive solution for databases

What needs improvement?

It would be interesting to have a cloud based database instead of having to install it on any single machine.

Which solution did I use previously and why did I switch?

Since Oracle was expensive for a company business an inexpensive way was to focus on PostgreSQL.

What other advice do I have?

You need to find a lot of time in order to find all functionality and get used to the PostgreSQL syntax Be patient, look for various forums and do learning by doing.
Consultant
CTO at a tech services company with 51-200 employees
Apr 30 2016

What is most valuable?

* Updatable views (also over multiple tables) * Array and JSON fields * Point-in-time backup and recovery (WAL files archiving)

What needs improvement?

I find, sometimes, that it is too restrictive in cross-table/view constraints. This is very annoying as I needed to change a field definition from VARCHAR(10) to VARCHAR(30) and, having a group of views depend in it, the only solution was to implement a function that would: * Read the view definitions * Store them * Delete the views * Update the field definition * Recreate the views It took me… more»

Which other solutions did I evaluate?

I've only used online open source resources and would say there's not as much as there is for MySQL. Sometimes it took me some time to find a good solution to the more unusual scenarios
Vendor
Technical Lead with 1,001-5,000 employees
Apr 30 2016

What do you think of PostgreSQL?

What is most valuable?

PostgreSQL gives you much more flexibility because it's open source.

How has it helped my organization?

It improves the query performance a lot and helped in some real time and analytic reporting

What needs improvement?

Sometimes it hangs and then we need to stop and start the services again

For how long have I used the solution?

I've used it for three years.

What was my experience with deployment of the solution?

We've had no issues with the deployment.

What do I think about the stability of the solution?

There have been no stability issues.

What do I think about the scalability of the solution?

We have had no issues scaling it.

How are customer service and technical support?

Customer Service: 7.5/10 Technical Support: 7.5/10

Which

Daniel Alejandro Zuleta Zahr
Real User
Developer at a tech services company with 11-50 employees
Apr 30 2016

What is most valuable?

* Stored Procedures * Full Text Search One of our products crawls information from different web sites and then detects if some keywords are there based on a business logic. The business logic was… more»

How has it helped my organization?

The Full Text Search functionality saved us a lot of time because we didn’t need to program that ourselves.

What needs improvement?

We don’t have any real database expert in the company, we are mostly developers. So I wouldn’t know if something would need improvement or we just haven’t learn how to use it properly yet. However… more»

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is free, so great ROI!

What other advice do I have?

At basic levels the database won’t do much difference, focus first in learning how to build queries properly, create index, etc. An image of our product achieved with Full Text Search.

Which other solutions did I evaluate?

We compared it to MySQL, Oracle and we though PostgreSQL Full Text Search functionality was the best for what we needed.
Vendor
Programador - Analista at a program development consultancy with 501-1,000 employees
Apr 28 2016

What is most valuable?

Common Table Expressions(CTEs). It's powerfull, easy to write and read and very flexible.

How has it helped my organization?

JSONB (Binary JSON storage), because I can have both relational and non-relation data storage at the same time with this data type. In addition, by using Generalized Inverted Indexes (GIN) it supports fast lookups and simple expression… more»

What needs improvement?

Replication is not yet as well implemented as in MySQL.

Which solution did I use previously and why did I switch?

I used MySQL, but for safety and consistency issues, I moved to PostgreSQL

What other advice do I have?

Currently this is one of the best solutions on the market. It is a tool without cost, powerful, easy to learn and with a large active community.
Consultant
Senior Production Support Engineer at a tech company with 501-1,000 employees
Apr 28 2016

What do you think of PostgreSQL?

What is most valuable?

It's reliability is key.

How has it helped my organization?

It allows us to deploy test functionality on a very simple normal computer and not on a server.

What needs improvement?

I'd like to have NoSQL available in this version. It is available in the latest one.

For how long have I used the solution?

I've been using it for six years.

What was my experience with deployment of the solution?

We had no issues with the deployment.

What do I think about the stability of the solution?

I've had no stability issues.

What do I think about the scalability of the solution?

It scaled for our needs.

How are customer service and technical support?

8/10

Which solution did I use previously and why did I switch?

I switched as I needed to increase…
Vendor
Co-Founder, Technical Manager, Consultant at a hospitality company with 51-200 employees
Apr 28 2016

What is most valuable?

* Flexible stored procedures and external functions * WITH clauses * Partitioning * Large open-source extensions, modules and software helpers eco-system

How has it helped my organization?

The documentation is very well written and detailed, it helps to implement the right features for your needs in a timely manner.

What needs improvement?

Parallel processing of queries.

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is free and open source.

Which solution did I use previously and why did I switch?

I used MySQL. PostgreSQL syntax is much clearer and consistent, and its stored procedures are powerful and fast. The documentation is also much better and of more help.

What other advice do I have?

Read the documentation.
Vendor
Director of Client Integration at a financial services firm with 51-200 employees
Apr 27 2016

What is most valuable?

The h-stores are very powerful for handling collections of key-value pairs. The query syntax and functions are well documented and easy to use.

How has it helped my organization?

PostgreSQL is a powerful and open source database, which is central all data processing.

What needs improvement?

We'd like to be able to start using JSON objects for easy code representation. This feature is available in v10.4.

Which solution did I use previously and why did I switch?

We were using version 8 before, and also an earlier Oracle instance. We chose the product because it is powerful, well documented, and open source.

What other advice do I have?

The challenge with this product would be finding the IT resource that can implement the product.
Consultant
Software architect at a tech services company with 51-200 employees
Apr 27 2016

What is most valuable?

Many supported features out of box like fulltext search, partitioning, easy replication - slony, pgpool-II and streaming wal and additional features such as JSON, XML, arrays in columns, and many… more»

How has it helped my organization?

I'm working as architect for a custom software development company and we are using Microsoft SQL Server, Oracle DB and PostgreSQL as our main databases, in recent years Postgre is offering more and… more»

What needs improvement?

The biggest issue that we are having is upgrading and moving databases between servers and versions. Restoring database is slow with pg_restore because indexes are need to be rebuilt. What I'm missing… more»

What's my experience with pricing, setup cost, and licensing?

There are no license fees for getting PostgreSQL and we don't yet have experience with paid support such as from EnterpriseDB, but we never needed it. Your first investment is only in people working… more»

Which solution did I use previously and why did I switch?

We are using PostgreSQL for new installations and new versions of our solutions where it's possible, and the customer does not require a specific SQL server. Nowadays it's covering all of our needs.

What other advice do I have?

My advice is to read documentation thoroughly and don't be afraid to look into source code. A great source is https://momjian.us/main/presentations/overview.html
Vendor
Director GIS/Analytics/IT at a non-profit with 501-1,000 employees
Apr 27 2016

What is most valuable?

Speed and price, it’s fast and reliable, and free.

How has it helped my organization?

Due to budget restraints procuring software is always an issue, and mainly production systems are well maintained. However development systems are not usually so well off. As PostgreSQL is free, this enables us to develop applications… more»

What needs improvement?

Simplicity in design and improvement with programming languages like PHP.

Which solution did I use previously and why did I switch?

We use both MySQL & PostgreSQL, some applications have better compatibility or built in tools, this decides which database we use.

What other advice do I have?

So far we have not had any issues with this database are we are using this in development and production systems.
Vendor
President with 51-200 employees
Apr 27 2016

What is most valuable?

It is fast, compact, flexible, and scalable. I like the fact it is not tied directly to a server OS, such as Microsoft SQL Server. Being open source it is very budget continuous for our clients.

How has it helped my organization?

There are a few little odds and ends like all SQL servers that differ from other SQL servers. The way it handles logical, the fact it does not support primary keys on views etc. My experience is all… more»

What needs improvement?

I would love to have primary keys on views. This function missing has made PostgreSQL harder than need be with Microsoft Access as a front end.

What's my experience with pricing, setup cost, and licensing?

Being open source this is not really applicable.

Which solution did I use previously and why did I switch?

We used Oracle, MySQL, Microsoft SQL Server. Oracle and Microsoft SQL Server were simply too expensive for smaller customers. MySQL had too many short comings to make it a workable solution.

What other advice do I have?

PostgreSQL is a great SQL database, powerful, flexible, but it is not something to be considered over other things. The most important issue for a database, if what back end do your mission critical… more»
Consultant
Senior Software Engineer at a tech services company with 51-200 employees
Apr 27 2016

What is most valuable?

HStore is a data type in PostgreSQL database that gives the flexibility for storing sets of key/value pairs which is quite an awesome feature.

What needs improvement?

Slow count. As the number of rows exceed a couple million, the count query and queries which get to the depth of the data (like FTS) start taking too much time even with all the right indexes in place.

Which solution did I use previously and why did I switch?

We tried RethinkDB a couple of years back, and it was unstable at that time. Also, MySQL didn't have a JSON type back then. We switched to PostgreSQL and never looked back.

What other advice do I have?

I'd recommend reading Greg Smith's PostgreSQL High Performance.
Vendor
DWH Analyst at a financial services firm with 1,001-5,000 employees
Apr 26 2016

What is most valuable?

The reason why I started with PostgreSQL database was the (geo)spatial support. GIS software, such as Quantum GIS (QGIS) or PostGIS, is a good example of where you are able to use this feature. Nowadays, the solution is on a competitive level to other commercial software solutions, especially for… more»

How has it helped my organization?

PostgreSQL (geo)spatial support is stable, and you can add, remove, and edit all standardized GIS features. Thanks to projects such as EDB, Bitnami etc., PostgreSQL can be used by people on pure user level, without deep knowledge of OS administration, programming.

What needs improvement?

There is room to improve some user friendly properties such as input and output tools, some people may find interesting to implement MERGE as a SQL command. I am looking forward to trying UPSERT and would like to test some analytic functions definitely.

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is a long-lasting investment for people who like computers and don’t want to spent much money for database layer implementation.
Consultant
Senior Programmer at a tech services company with 51-200 employees
Apr 26 2016

What is most valuable?

* Easy to use * Vastl documentation * Tough product

How has it helped my organization?

We used it from scratch of the organization. It helped a lot since we could improve our hardware, and we upgraded the Heroku plan as we grew.

What needs improvement?

It could be easier to perform some fragmentation in the database. It's possible, but still a hard job.

Which solution did I use previously and why did I switch?

I used other solutions in other companies I've worked for before. When I arrived at my current company they were already using PostgreSQL.

What other advice do I have?

It does what it's supposed to do, as simple as that. We don't regret any choosing this solution.
Consultant
Team Lead ETL at a tech services company with 51-200 employees
Apr 25 2016

What is most valuable?

JSON data support is most valuable to me as it saves design and maintenance time. It is a very safe and stable solution.

How has it helped my organization?

We are spending less time parsing API response and more time exploring data. We spend time understanding APIs and how to interact with them, If we can load responses directly to the database that saves many man hours for a project.

What needs improvement?

A better export facility which is GUI friendly would be an improvement. Also if we could export data from grid that would have been helpful.I have used HeidiSQL for MySQL which is very user friendly, pgAdmin III is not that helpful when it… more»

Which solution did I use previously and why did I switch?

I have worked with MySQL, Microsoft SQL, db2, and Oracle. We chose PostgreSQL for its JSON support as our APIs are sending JSON responses and PostgreSQL is like home for JSON. Choosing it has helped our cloud computing requirements a lot.

What other advice do I have?

If you are thinking of using PostgreSQL, all database names, table names and column names should be in small letters. PostgreSQL requires every capital letter to be quoted which makes life difficult for developer.
Vendor
Technical Account Manager with 1,001-5,000 employees
Apr 25 2016

What is most valuable?

* Stability * Performance * Ease of administration

How has it helped my organization?

It is a world class, performer, a scalable database that is free and open source.

What needs improvement?

At the fringes, you can have locking problems that can cause unacceptable pause, but that's really a factor of database design, and the limitations of relational databases as a technology than a particular issue with PostgreSQL

Which solution did I use previously and why did I switch?

We've got experience with a number of RDBMS, but PostgreSQL has always stuck out to be the most economical and sensible product. That being said, we do have instances of Maria, and various NoSQL's floating around.
Consultant
Sysadmin at a tech services company with 51-200 employees
Apr 24 2016

What is most valuable?

It is an open source solution and that is a database engine very powerful. Besides it is highly configurable. I prefer PostgreSQL over MySQL or MariaDB because you can create several databases with… more»

How has it helped my organization?

PostgreSQL is a powerful dateserver although not like Oracle. So we can make many developments in a cheaper way with high availability. Besides, its very useful tool for debugging with a soft learning… more»

What needs improvement?

It needs to be able to cluster. We have implemented the high availability with a master-slave mode and one host in only read mode. This is the worst feature of this product and the quality sign of… more»

What's my experience with pricing, setup cost, and licensing?

It's open source code, so you get it for free and need to contribute to debugging errors and improving the code.

Which solution did I use previously and why did I switch?

I use MySQL, MariaDB, and Oracle. I chose PostgreSQL or others depending of the project. For Java implementations I prefer PostgreSQL, and for PHP development, I prefer MySQL or MariaDB,

What other advice do I have?

Be patient! Like most open source tools, this requires commitment and a little knowledge. * pg_hba.conf * A fragment from postgresql.conf * How to access to database-server using psql client, and… more»
Vendor
NOC Manager with 51-200 employees
Apr 24 2016

What is most valuable?

The product is free, which is a huge benefit. There are options to create clusters and maintenance on the databases is easy and fast. The management studio with product is create and intuitive.

How has it helped my organization?

We used this product for applications which require a database. Since MS SQL Express has limitations and regular MS SQL requires pricey licensing, PostgreSQL was an easy choice. The deployment is… more»

What needs improvement?

The commands for PostgreSQL work, but are behind the curve compared to Microsoft SQL and MySQL. Adding additional functionality to be move comparative to Microsoft SQL would be a nice to have. For… more»

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is free to use.

Which solution did I use previously and why did I switch?

We use Microsoft SQL (all versions), MySQL, PostgreSQL, SQLite, etc. We use PostgreSQL when the application supports it and where it makes more economic sense to use it.

What other advice do I have?

Ensure its a good fit for the application you are using and integration you may have planned. Review all documentation prior to moving forward and always test the new versions before just cutting… more»
Vendor
DevOps Engineer at a transportation company with 51-200 employees
Apr 24 2016

What is most valuable?

By far indexes is the most useful and robust feature. Also, the query optimization engine is simply great. It is very complete, clear and useful documentation, forums and diverse information channels.

How has it helped my organization?

Most of the enterprise I have worked has been startups and small to medium software industry and data analysis. One of the most improvement it is not in the mean time but in the middle to long time… more»

What needs improvement?

I think that data types that decrease the breach against NoSql Databases will be the next steps. I am not talking about changing to a pure NoSql DB but to some features that will face the big change… more»

What's my experience with pricing, setup cost, and licensing?

PostgreSQL license is a fair enough for small to medium size business solutions.

Which solution did I use previously and why did I switch?

I have worked with MySQL and Oracle solutions. Against MySQL, performance is the big difference. PostgreSQL is far more robust and mature than MySQL, especially when you think about keys and indexes… more»

What other advice do I have?

Just read the comparisons between different database engines, and read some documentation so you can exploit most of the powerful tools and functions it has.
Consultant
Senior Consultant / Manager Technical Operations at a tech consulting company with 501-1,000 employees
Apr 20 2016

What is most valuable?

* Security * HA and DR * Performance * Maintenance

How has it helped my organization?

I worked as a consultant/trainer. I have a few installations of Dev/Test in my VMs, and I don't have anything in the production installation in our organization.

What needs improvement?

It's not very user friendly, as it is open source and has no immediate support. You can download the Enterprise version of Postgres that is a GUI installation and also have a support contract.

What's my experience with pricing, setup cost, and licensing?

The core product is free but you have to pay for third-party utilities / plugins and support.

What other advice do I have?

* Positive - 100% free as it's open source * Negative - it's hard to find expertise If you are planning to migrate an existing environment, please go through with the full UAT cycle at data… more»

Which other solutions did I evaluate?

I have evaluated MySQL and Ingres previously and then PostgreSQL. My personal choice is PostgreSQL. I also worked on a migration project from Ingres to Oracle.
Consultant
Manager at a tech services company with 51-200 employees
Apr 20 2016

What is most valuable?

The most valuable features are a good feature set, understandable, and good tuning features. It is, also in our experience, the best open source GIS enabled database, with good support from other open-source tools. The product has easy… more»

How has it helped my organization?

The database is used to set-up customers projects and is our standard database which we use.

What needs improvement?

One of the features it needs is a tighter integration with business intelligence software, so that the optimisation of the requests can be handled natively in the database. These features are on the roadmap, and are already partially… more»

What's my experience with pricing, setup cost, and licensing?

The pricing of the database is open-source and our investment in the product is based on training.

Which solution did I use previously and why did I switch?

We have been using Oracle software, and in some cases MS SQL server. The price difference between the used products and PostgreSQL was one of the issues. The second was the ease of installation and the availability on different platforms.
Vendor
Owner with 51-200 employees
Apr 19 2016

What do you think of PostgreSQL?

Valuable Features

It can handle complex SQL queries.

Improvements to My Organization

It has helped to cut costs because it's open source.

Room for Improvement

It needs better support for JSON and web services.

Use of Solution

I've been using it for 13 years.

Deployment Issues

We had no deployment issues.

Stability Issues

We've had no stability issues.

Scalability Issues

There have been no issues scaling it for our needs.

Customer Service and Technical Support

It's open source, so there's no technical support available.

Initial Setup

It was simple to setup.

Implementation Team

We implemented it with our in-house team.

ROI

There was an immediate return-on-investment of 100%.

Other Solutions Considered

We also looked at MySQL and other databases…
Vendor
Founding Partner at a tech vendor with 1-10 employees
Jul 31 2015

What is most valuable?

It supports full text search, and windows functions.

How has it helped my organization?

All our data is stored in PostgreSQL, and we use a BI solution on top to gather all the important metrics to our business, so the whole company has a clear picture of what… more»

What needs improvement?

It lacks the ability to distribute queries across multiple installations out of the box.

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is free software. The only cost of setup was a few developer hours, and with it being stable, we don't have any day-to-day costs.

Which solution did I use previously and why did I switch?

I used MySQL, but I needed support for full text search. PostgreSQL adds this, and also many more advanced SQL functions.

What other advice do I have?

PostgreSQL is one of the most stable data sources out there, and it offers you the most advance and modern functions on SQL so you can do more with less.

Which other solutions did I evaluate?

* MySQL * Microsoft SQL Server
Vendor
Software Engineer at a tech vendor with 1,001-5,000 employees
May 14 2015

What do you think of PostgreSQL?

Use of Solution:

6 years

Deployment Issues:

Authentication config could be made easier.

Stability Issues:

It's very stable.
Consultant
Database Expert at a tech services company with 51-200 employees
Apr 30 2015

What is most valuable?

The use of extensions for integration with different databases is valuable.

How has it helped my organization?

Our organization has MySQL, Oracle, PostgreSQL and flat files in our processes, and the use of extensions has facilitated the integration between these processes. Also… more»

What needs improvement?

The use of XQuery besides XPath into PostgreSQL. It would also be nice for them to add some backup features similar to the one that Oracle Recovery Manager has. Also, a… more»

What's my experience with pricing, setup cost, and licensing?

We didn't have any setup costs because it is free.

Which solution did I use previously and why did I switch?

We initially only used an Oracle database, but we decided to add PostgreSQL as an option because of its similarity to Oracle. Also, it's free and is the best open source… more»

What other advice do I have?

I'd say go for it. It is stable, and easy to use but you should get an understanding of it to implement backup strategy.

Which other solutions did I evaluate?

* MySQL * SQL Server * Sedna XML
Vendor
Database Engineer at a financial services firm with 1,001-5,000 employees
Apr 20 2015

What do you think of PostgreSQL?

What is most valuable?

It allows us to have an alternative solution to licensed DB's.

How has it helped my organization?

It requires enterprise integration improvements from the security, and audit perspective (AD integration etc.). Also, integration into existing BI tools is not present.

For how long have I used the solution?

I've used it for three years.

How are customer service and technical support?

They provide a high level of technical support.

Which solution did I use previously and why did I switch?

We switched due to a common OS integration strategy.

Which other solutions did I evaluate?

We had an RFP process to evaluate between similar product categories.
Vendor
Business Analyst at a transportation company with 1,001-5,000 employees
Aug 10 2014

What do you think of PostgreSQL?

What is most valuable?

Backend: 64-bit large objects, Cascading streaming replication, Serializable Snapshot Isolation; Performance:GIN Index performance and size improvements; Security: SSPI authentication via GSSAPI; list goes on...

How has it helped my organization?

Automation, accurateness and concistency of enterprize processes

What needs improvement?

Comercial & Supply Chain

For how long have I used the solution?

9 years

What was my experience with deployment of the solution?

No

What do I think about the stability of the solution?

No

What do I think about the scalability of the solution?

No

How are customer service and technical support?

Customer Service: 9Technical Support: 9

Which solution did I use previously and why did I switch?

MySQL: scalability;…
Vendor
Database Expert with 201-500 employees
Feb 27 2014

What do you think of PostgreSQL?

PostgreSQL at glance PostgreSQL is a first class product with high end enterprise class level features. This first chapter is a general review on the product with a brief talk on the database's history. A long time ago in a galaxy far far away... Following the works of the Berkeley's Professor Michael Stonebraker, in 1996 Marc G. Fournier asked for any volunteer interested in revamping the Postgres 95 project. The answer came from Bruce Momjian,Thomas Lockhart, and Vadim Mikheev, the very first PostgreSQL Global Development Team. Features Every time a new major release is released, new powerful features join the rich set of the product's functionalities. Here is a small excerpt of what the latest version offers in terms of flexibility and reliability. Write…
Vendor
Database Expert with 201-500 employees
Feb 14 2014

What is most valuable?

The SQL is very close to the standard, the richness of of procedural languages and the strong attitude to the data reliability.

How has it helped my organization?

The product is used to ensure the data delivery and the HA features are used to enforce a non stop service.

What needs improvement?

The partitioning, is still very basic and not touched for years.

What's my experience with pricing, setup cost, and licensing?

Basically zero for both. The product is released under the BSD license and, apart from my salary, my employer have no extra costs on using PostgreSQL

Which solution did I use previously and why did I switch?

I worked for years on Oracle. I decided to move on PostgreSQL because I think is a first class product.

What other advice do I have?

Employ a DBA to work together with the developers.

Which other solutions did I evaluate?

I considered in the past MySQL and Firebird.
Vendor
Developer at a university with 51-200 employees
Apr 17 2013

What is most valuable?

Before PostgreSQL, I am an avid user of MySQL for a long time. When I began my masters in a renowned school, I was introduced to PostgreSQL and started to like it. Here are the few things I have loved about Postgres: • It is free and compatible in all platforms • It performs very quickly and can outperform Oracle, SQL server and IBM DB2 • It uses SQL windowing functions which are rarely found in… more»

What needs improvement?

• Windows versions were released ten years after the initial release • Replication is not so powerful in later versions • Postgres is not so popular compare to MySQL • PostgreSQL community has lesser support

What other advice do I have?

I cannot stress how highly I recommend PostgreSQL to my fellow programmers. The features and functionalities are beyond the abilities of other free database platforms and are comparable to the proprietary ones. Some advanced features may also be seen to the license databases but you’ll amaze how advance PostgreSQL may become in the future but in zero cost.
Consultant
Developer at a tech consulting company with 51-200 employees
Aug 04 2012

What is most valuable?

1) Supports large part of SQL standards like Complex queries, stored procedures.2) As source code is free and open, it can be easily distributed, modified and extended according to user requirements.3) PostgreSQL also proves to be a cost-effective solution for organization's as this product is designed and created to have much lower maintenance without compromising on features.4) Excellent GUI… more»

What needs improvement?

1) It tends to be slower when processing a large number of records.2) Does not support the entire ANSI SQL 92' standard.3) More open source applications (software stacks) supports MySQL, but some of them may not support PostgreSQL4) Comparatively small user community than MySQL 5) Installation and setup is bit complex and requires technical know how. Though PostgreSQL is comparatively slower than… more»

What other advice do I have?

Great Documentation, active community support, excellent management & development tools and availability on various platforms makes PostgreSQL a good data base management system.
Consultant
Tech Support Staff at a tech services company with 501-1,000 employees
Jul 20 2012

What is most valuable?

Out of all the open source database applications available, PostgreSQL is among the best DB storage engines with a single unified database server unlike MySQL which supports multiple storage engines for storing the data. PostgreSQL was specifically designed and developed with a focus on features and standards whereas MySQL was designed with a focus on speed. So, if you are looking for a large… more»

What needs improvement?

PostgreSQL does not multiple back-end storage engines unlike MySQL. It does not perform well when dealt with read-only DB queries. It is not very efficient in handling COUNT(*) queries. PostgreSQL does not support queries like 'INSERT IGNORE', which inserts if a row doesn't exist, and 'REPLACE' which replaces the current row, both of which are supported by MySQL. Another query missing from… more»

What other advice do I have?

PostgreSQL is one of the best open source DB storage application which supports only one backend storage engine. PostgreSQL is well known for the number of features it supports and the standards followed. PostgreSQL is pretty slow when dealing with queries like COUNT(*) and many of the queries like 'INSERT IGNORE', which inserts if a row doesn't exist, and 'REPLACE' which replaces the current row… more»

What is PostgreSQL?

PostgreSQL is a powerful and fully-featured database management system with which business owners can create object relational tables. It is an open source project that can be acquired for free and heavily focuses on elements such as extensibility and strict standard compliance. PostgreSQL is a flexible server system that can manage large workloads that are being contributed and accessed from a wide range of locations such as in a network, as well as small-scale projects like a single machine or user.

Some technical details of interest about PostgreSQL include:

  • Its MVCC (Multi-inversion concurrency control) allows fluid changes to be made to the system without cumbersome roadblocks, while maintaining the optimal level of ACID.
  • Replication, built-in binary replication is available from the 9.0 version and later.
  • It offers a wide range of indexing capabilities, including B-tree and hash indexes, as well as GIN and GiST (generalized inverted indexes and generalized search trees).
  • It uses procedural languages that make it easier for developers to expand the database.
PostgreSQL customers

Hundreds of companies have used PostgreSQL, including the University of Alabama, Birmingham, Berkman Center for Internet & Society at Harvard University, Champion Products, the United Nations Industrial Development Organization, the U.S. Agency for Disease Control and Prevention, and IMDB.com.

BUYER'S GUIDE
Download our free Open Source Databases Report and find out what your peers are saying about PostgreSQL, Firebird, EnterpriseDB, and more!