Multicolumn statistics, Index-only scans, Sophisticated query optimizer/planner.Indexing: Partial, Expressions, Multicolumn.Advanced Indexing: Bloom filters, Covering Indexes, BRIN, GIN, KNN Gist, SP-Gist, Gist.Customizations: Custom Types, Composite.Document: Key-value (Hstrore), XML, JSON/JSONB.Primitives: Boolean, String, Numeric, Integer.

Structured: UUID, Range, Array, Date/Time.The following are some essential aspects detected in PostgreSQL, these aspects are included in all the major release. Besides of being open and free source, it is a highly extensible database.įor example, we can define our data types, made custom functions, and write code through programming languages of different types without recompiling our database. It also supports us for managing our data. It comes with several aspects aimed to support administrators for protecting integrity of data, developers for building applications and build an environment, i.e., fault tolerance. It has become an open source type of relational database for various organizations and people. PostgreSQL has strong add-ons like the popular geospatial database extender, i.e., PostGIS. PostgreSQL delivers innovative and performant solutions consistently. PostgreSQL has made a solid reputation for the reliability, architecture, data integrity, extensibility, robust aspect set, and open source community's dedication. PostgreSQL's origins back to date 1986 at the California University at Berkeley as the POSTGRES project. It extends and uses the languages of SQL that consisted of various aspects that safely scale and store sophisticated data workloads. PostgreSQL is an open-source, powerful object-relational type of database system. Next → ← prev Install PostgreSQL MAC PostgreSQL Introduction

Setting up postgresql mac