PostgreSQL Reviews & Product Details - Page 36

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.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

2/22/2019

"The perfect Database"

4.5/5

What do you like best about PostgreSQL?

Its a fast and secure database. We use it in all our projects. And it is free! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I absolutely have no complaints about postgreSQL. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

2/16/2019

"Postgresql"

5/5

What do you like best about PostgreSQL?

I helped transition from SQL to postgres, I must say they way data is stored was of liking to me. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The documentation doesn't specify detail about what happens when multiple factors work together Review collected by and hosted on G2.com.

Gurmeet S.

Programmer Analyst

Information Technology and Services

Mid-Market (51-1000 emp.)

7/12/2018

"One of the best open source databases."

3/5

What do you like best about PostgreSQL?

Nice clean user interface.

Its one of the best open source database.

Administrator control and configurations are good.

Ease of creating schema and tables is also good. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of features compared to Microsoft sql server and oracle database.

Stability is very important feature to have in any database. That needs improvement. Review collected by and hosted on G2.com.

Rahul D.

Mid-Market (51-1000 emp.)

8/28/2018

"An Amazing Relational DBMS with Json Functionalities."

5/5

What do you like best about PostgreSQL?

PostgreSQL is the most amazing DBMS available in the market. It makes provides with all the power of Relational Database system plus of the flexibility of using JSON data types The Latest Postgres 10 provides an extensive approach for Partitioning and data workers which are very helpful for handling very large data object. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When handling a data set of a few million record, you need to carefully analyze your query plan as it can effect your performance badly. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

12/20/2018

"The World's Most Advanced Open Source Relational Database"

5/5

What do you like best about PostgreSQL?

PostgreSQL provides various kind of hooks. Some of these hooks can be utilized to make access control decision on the supplied users' accesses on database objects. We call plug-in modules making access control decision based on its own security model as an external security provider. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Make more advertising and training programs Review collected by and hosted on G2.com.

Verified User in Internet

Mid-Market (51-1000 emp.)

8/2/2018

"Nice Old fashioned RDBMS for general use"

4/5

What do you like best about PostgreSQL?

This database is complaint to ANSI and has good number of functions which are mostly used in ETL jobs. Most recent AWS Redshift is based on the architecture of Postgres. Relatively fast and intuitive. Supported by most of the standalone and IAAS softwares which makes it usable on any platform. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some of the function I really need are not supported in here. It could have been faster but being a relational database that is what we have to give up. Also it is little hard to connected different databases. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Go for it. if you are looking for latest best RDBMS with better industry level support. It won't hurt you look around with AWS Redshift which is more scalable and fast. Review collected by and hosted on G2.com.

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

Building a data warehouse using 5 of these separate Postgres Instances. Review collected by and hosted on G2.com.

Verified User in Banking

Small-Business (50 or fewer emp.)

3/12/2019

"Adhoc Querying"

3/5

What do you like best about PostgreSQL?

Execution time is most done after clicking the button. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Securtiy Features to be rolled as production database. Review collected by and hosted on G2.com.

ALEXANDER J.

Ingeniero III

Enterprise (> 1000 emp.)

1/3/2018

"Excellent Database Manager"

5/5

What do you like best about PostgreSQL?

Database with excellent features to store data, integration with many applications developed in different languages of application development, compatibility with Windows operating systems, Linux, etc. Ease of integration with ETL solutions, to store data warehouses to interact with business intelligence software, allows replication of data with streamig replication, the availability of operational continuity through the implementation of pgpool, binaries to perform backup and recovery processes , implementation of WAL, possibility of executing auto vacuum to keep the objects of the database clean, version updates of the postgresql SMBD, are easy and applications are not affected. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The postgresql database management system has a weakness that does not have high availability mechanisms, does not include cluster administration, only includes isolated tools for the implementation of continuity of service, and integrates a group of solutions to support postgresql as This is the case of pgpool Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Before the implementation of postgregar in your infrastructure, make a test plan for the compatibility of the applications developed, perform a intonation postgresql of SMBD, so that the performance of the work is adjusted to the servers where it is installed. Implement a backup and backup plan, install a good software to monitor the performance of the database, I recommend NAGIOS as software for monitoring, from my own experience I recommend installing the postgresql SMBD under the Debian operating system, and verify the configuration files to customize the parameters for the best performance of the postgresql SMBD. Review collected by and hosted on G2.com.

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

Reduce maintenance and licensing costs Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

2/6/2019

"My experience"

4/5

What do you like best about PostgreSQL?

Handles transactions better

More query features

Uses r trees

Most advanved open source relational database Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not enough scalability

Not that popular

Not enough community support Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Enterprise (> 1000 emp.)

11/26/2018

"Open Source Database Excellence"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is free, simple to use and has a great graphical user interface that is not clunky and confusing like some of the competition. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The biggest detractor for the software for me is the support documentation. Typically open source products have better support databases. Review collected by and hosted on G2.com.