PostgreSQL Reviews & Product Details - Page 40

admin

PostgreSQL Overview

edit

What is PostgreSQL?

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

PostgreSQL Details

Discussions

PostgreSQL Community

Show LessShow More

Product Description

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

Seller

PostgreSQL

Description

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

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

Overview Provided by:

Avi Ashkenazi

CTO at Coronys LTD.

PostgreSQL Integrations

(3)

Integration information sourced from real user reviews.

PostgreSQL Media

PostgreSQL

G2 reviews are authentic and verified.

Here's how.

Alexander C.

Consultor Tecnico - JavaDeveloper

Mid-Market (51-1000 emp.)

7/5/2018

Business partner of the seller or seller's competitor, not included in G2 scores.

"robust and stable"

4.5/5

What do you like best about PostgreSQL?

easy to use, one of the best database managers to develop complex applications, apart from being robust and simple. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is usually very basic, it would require more functionalities to be of this tool, a more complete tool, additionally the installation is usually somewhat tedious as it requires certain dependencies. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

4/26/2018

"Awesome Tool!"

5/5

What do you like best about PostgreSQL?

The best things I like about PostgreSQL is all the functions and tools it provides to perform fast querying and calculations. Also I actually love how it integrates with other tools such as Postgis, that we used it to draw polygons and check if certain coordinates where inside these or not. It worked incredibly fast. Finally I love psql, is my goto tool, really fast to open a new connection to a database and perform queries right away over this one. I also love that the tool is open source, I'm a big supporter of that Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't dislike much about it, just that sometimes the querying is kind of slow when you are trying to get loads of data out of the db. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It is a tool that has a huge community around it that it is always there to help through the different communication channels you have. Moreover it is really easy to set it up and also not difficult to learn. So developers will be able to reach a high level of understanding in little to no time. Review collected by and hosted on G2.com.

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

We are storing large amount of data in our db's to later perform analytics with it. The main benefits we've realize while using it is the large amount of functions and transformation we can perform while querying. It actually makes our life easier. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

3/27/2018

"Great Alternative to traditional Commercial Databases"

4/5

What do you like best about PostgreSQL?

PostgreSQL has grown in both popularity and features. It is now on par with many of the commercial database servers. Because of its popularity, if you need commercial support, you can find it. If you can go it all alone, you can save you (and your company money). It is available for many OSes to suite your needs Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Windows support has lagged behind Linux/Unix for a number of years. Some of the tooling feels weird when you run it on Windows. I think if they want better adoption on Windows, they should create native (non-cli) tools. Review collected by and hosted on G2.com.

Verified User in Computer & Network Security

Enterprise (> 1000 emp.)

11/24/2018

Business partner of the seller or seller's competitor, not included in G2 scores.

"PostgreSQL is a best choice database for small to medium size organizations"

4.5/5

What do you like best about PostgreSQL?

Light wait. quick installation, Great documentation, Hundreds of online forums Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Partitioning is not as good as Oracle. PostgreSQL slows down when joining very large fact tables in VLDB environment. Review collected by and hosted on G2.com.

Verified User in Retail

Enterprise (> 1000 emp.)

1/3/2019

Business partner of the seller or seller's competitor, not included in G2 scores.

"PostGRES is same as Oracle SQL"

4/5

What do you like best about PostgreSQL?

PostGres follows ANSI SQL like Oracle does Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Less documentation and not like Oracle which have mature documentation Review collected by and hosted on G2.com.

Sharon L.

Small-Business (50 or fewer emp.)

7/30/2018

"PostgreSQL is a reliable data storage system"

4.5/5

What do you like best about PostgreSQL?

It is really compatible with other SQL languages and is very easy to use for persistent data storage. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Generally, PostgreSQL has a slight learning curve for newer developers to SQL. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness

Enterprise (> 1000 emp.)

10/19/2018

"High performant MPP - Postgres"

4/5

What do you like best about PostgreSQL?

The parallel processing capability and scalability of PostgreSQL. Opensource Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It could have more monitoring tools as provided by other implementations of PostgreSQL Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

7/31/2018

"Reliable and Configurable Relational DB"

4.5/5

What do you like best about PostgreSQL?

The best thing about postgres is that it is open source and you can install many extensions to make it perform the way you want. It has extensions for distributed storage and even GPU support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing in particular but one of the cons of this database is that it is not meant to handle large volumes of data effectively. Review collected by and hosted on G2.com.

Verified User in Education Management

Enterprise (> 1000 emp.)

12/15/2018

"Good experience "

5/5

What do you like best about PostgreSQL?

Data warehouse functionality and the option of retrieval and indexing Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Syntactical and symantic complexity but it can be overcome Review collected by and hosted on G2.com.

DomesticallyNerdy T.

Junior QA Tester

Financial Services

Mid-Market (51-1000 emp.)

10/25/2017

"Simple and easy to use"

4/5

What do you like best about PostgreSQL?

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

What do you dislike about PostgreSQL?

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

Recommendations to others considering PostgreSQL:

Learn up on SQL! Review collected by and hosted on G2.com.

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

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