PostgreSQL Reviews

• PostgreSQL streaming replication
• PITR-based backups
• CTE SQL
• SQL windowing functions

• 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 return the number of rows affected even if the affected rows are in a partition

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 with the likes of Oracle & DB2 and hold its own in terms of features and performance, in many cases beating the competition.

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.

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

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

I've been using it for eight years.

We've had no issues with the deployment.

There have been no stability issues.

It's been able to scale for our needs.

I use online documentation, which met my needs.

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.

I did not set up the actual installation. I did set up the schema, tables, foreign keys, etc. That was straightforward in that it was well documented.

In house. You do need someone that knows PostgreSQL or that can spend time learning about the product.

It's open source. ROI is a matter of time.

The challenge with this product would be finding the IT resource that can implement the product.

We use PostgreSQL as a database for our ERP system.

There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time. We haven't tried the latest version, but they're supposed to add some of the most important things.

I've been using PostgreSQL for nearly 20 years.

PostgreSQL is stable. It's available, stable, and reliable.

Installing PostgreSQL is not so easy, and the installation takes about one day.

I rate PostgreSQL eight out of 10. I would definitely recommend it.

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.

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

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.

I've used it for 4 years now.

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 extensions for it as PostGIS.

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 useful features which we can use. For its open source model and very good documentation is very easy to optimize queries within bigger databases (100GB). Also its free and its lowering price of our solution so we can (and we are) address smaller customer.

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 is a query profiler similar to what is in Microsoft SQL Server. PgAdmin should also be easier to use for beginner users.

We have been using PostgreSQL for about 10 years.

After many years of usage we are not experiencing any unusual problems with PostgreSQL.

After many years of usage we are not experiencing any unusual problems with PostgreSQL.

After many years of usage we are not experiencing any unusual problems with PostgreSQL.

We are not using customer service or technical support.

We are not using customer service or technical support.

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.

Depends, for basic setup, it is quite straightforward but for more advanced features (like WAL streaming and hash indexes) it is a bit harder during the first few days because of a lack of documentation and experience.

We did it in-house.

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 with PostgreSQL, and it is the same as with Microsoft SQL Server, but less than with Oracle. Hardware costs are lower for PostgreSQL and Oracle but those are not significant.

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

• Stability
• Performance
• Ease of administration

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

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

I've been using different versions of PostgreSQL for the past eight years.

There was other a foreseen issues with pushing it to the edge.

It's a very stable product.

It's easily scalable.

The amount of community support for the solution is good.

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.

We did it in-house.

We deployed the Postgre database on CentOS, which is a version of Linux. We have experimented with our replication and other operations. It works perfectly well. We are using the open-source version and do not plan on using any enterprise database.

PostgreSQL could improve by adding data warehousing tools.

I have been using PostgreSQL for approximately eight years.

PostgreSQL is stable.

The solution is scalable, it is very good.

We have approximately 100 users using this solution.

There is a lot of community support online to help with many things, such as updates. The online support is very active.

The installation is straightforward and simple, it took only half an hour.

We did the implementation through an in-house IT engineer.

We have a team of approximately five engineers that manage the solution.

We are using the free version of PostgreSQL.

I would recommend this solution to others.

I rate PostgreSQL a nine out of ten.

We use this solution as part of our backend to store data that is coming from the sensors. 

It is needed to save the meter data from the sensors.

It is easy to use.

It could be more secure.

I have been working with PostgreSQL for approximately two years.

I am using the latest version.

PostgreSQL is a stable solution.

We use this solution for organization's applications at the backend and it is not used directly by the end-users.

I have not contacted technical support.

It is a bit different from Oracle, with respect to security.

The initial setup is straightforward.

It was a token installation, I can do it myself.

I would recommend PostgreSQL to others who are interested in using this solution.

I would rate PostgresSQL a seven out of ten.