PostgreSQL 10+

GPTKB entity

Statements (95)
Predicate Object
gptkbp:instanceOf relational database management system
gptkbp:developer gptkb:PostgreSQL_Global_Development_Group
https://www.w3.org/2000/01/rdf-schema#label PostgreSQL 10+
gptkbp:latestReleaseVersion PostgreSQL 16
gptkbp:license gptkb:PostgreSQL_License
gptkbp:openSource true
gptkbp:operatingSystem gptkb:Windows
gptkb:macOS
gptkb:Linux
gptkbp:programmingLanguage C
gptkbp:releaseDate 2017-10-05
gptkbp:supports gptkb:BRIN_indexes
gptkb:citext_extension
gptkb:pg_stat_statements_extension
gptkb:pg_trgm_extension
gptkb:pgcrypto_extension
gptkb:SSL/TLS_encryption
gptkb:PL/pgSQL
gptkb:PL/Perl
gptkb:PL/Python
gptkb:PL/Tcl
internationalization
full-text search
transactions
roles and permissions
extensibility
indexes
arrays
collation
ACID compliance
foreign keys
materialized views
stored procedures
triggers
user-defined functions
views
custom data types
window functions
partitioned tables
user-defined types
hstore
table partitioning
custom functions
point-in-time recovery
GIN and GiST indexes
background workers
custom operators
event triggers
foreign data wrappers
hash indexes
hot standby
identity columns
logical decoding
logical replication
parallel query
pluggable storage engines
range types
user-defined aggregates
user-defined operators
uuid-ossp extension
unique constraints
check constraints
parallel query execution
full Unicode support
savepoints
JSON data types
primary keys
multi-version concurrency control (MVCC)
PL/Java (via extension)
PL/R (via extension)
PL/V8 (via extension)
SCRAM-SHA-256 authentication
custom aggregates
custom index methods
declarative partitioning
geospatial data (PostGIS extension)
improved parallelism
multi-byte character encodings
multi-column statistics
parallel aggregation
parallel bitmap heap scans
parallel hash joins
parallel index scans
parallel merge joins
pg_partman extension
pg_repack extension
pglogical extension
pluggable procedural languages
quorum commit for synchronous replication
replication slots
user-defined index methods
write-ahead logging (WAL)
gptkbp:website https://www.postgresql.org/
gptkbp:bfsParent gptkb:dbt-postgres
gptkbp:bfsLayer 8