description

PostgreSQL is a open source relational database system and is also knows as Postgres.

Type

RDBMS, ORDBMS

Written In

C

Developed By

PostgreSQL Global Development Group

Customers

Welltok Inc., BiggerPockets, Comcast, PDI Inc., Verizon

Releases

- 6.0.0 (1997-01-29)

Initial Release

- 9.4.22 (2019-05-09)

JSONB data typeALTER SYSTEM statement for changing config valuesAbility to refresh materialized views without blocking readsDynamic registration/start/stop of background worker processesLogical Decoding APIGiN index improvementsLinux huge page supportDatabase cache reloading via pg_prewarmRe-introducing Hstore as the column type of choice for document-style data

- 9.5.17 (2019-05-09)

UPSERTRow level securityTABLESAMPLECUBE/ROLLUPGROUPING SETSNew BRIN index

- 9.6.13 (2019-05-09)

Parallel query supportPostgreSQL foreign data wrapper (FDW) improvements with sort/join pushdownMultiple synchronous standbysFaster vacuuming of large table

- 10.8 (2019-05-09)

Logical replicationDeclarative table partitioningImproved query parallelism

- 11.3 (2019-05-09)

Increased robustness and performance for partitioningTransactions supported in stored proceduresEnhanced abilities for query parallelismjust-in-time (JIT) compiling for expressions

- 12 Beta 1 (2019-05-23)

REINDEX operation without blocking any writes to the indexWITH queries can now be automatically inlined in a queryATTACH PARTITION can now be performed without blocking concurrent queries on the partitioned tablepg_verify_checkums command has been renamed to pg_checksumsJust-in-Time (JIT) compilation is now enabled by defaultOIDs can no longer be added to user created tables using the WITH OIDs clause