PostgreSQL

GPTKB entity

Statements (105)
Predicate Object
gptkbp:instanceOf relational database management system
gptkbp:developer gptkb:PostgreSQL_Global_Development_Group
gptkbp:hasFeature gptkb:BRIN_indexes
gptkb:SP-GiST_indexes
gptkb:citext_extension
gptkb:dblink_extension
gptkb:fuzzystrmatch_extension
gptkb:libpq_client_library
gptkb:ltree_extension
gptkb:pg_basebackup_utility
gptkb:pg_dump_utility
gptkb:pg_restore_utility
gptkb:pg_stat_statements_extension
gptkb:pg_trgm_extension
gptkb:pgcrypto_extension
gptkb:psql_command-line_tool
data compression
role-based access control
materialized views
user-defined functions
row-level security
user-defined types
hstore
table partitioning
point-in-time recovery
GIN and GiST indexes
JSONB
SSL/TLS support
array types
asynchronous replication
b-tree indexes
background workers
covering indexes
cube extension
event triggers
expression indexes
foreign data wrappers
generated columns
hash indexes
hot standby
identity columns
incremental sort
just-in-time compilation (JIT)
logical decoding
logical replication
logical replication publications/subscriptions
logical replication slots
multi-version concurrency control
multirange types
parallel index creation
parallel query
partial indexes
partition-wise join
pgAdmin GUI tool
pluggable storage engines
range types
scram authentication
synchronous replication
tsvector and tsquery types
user-defined aggregates
user-defined indexes
user-defined operators
uuid-ossp extension
write-ahead logging
https://www.w3.org/2000/01/rdf-schema#label PostgreSQL
gptkbp:influenced gptkb:Amazon_Redshift
gptkb:Vertica
gptkb:Greenplum
gptkb:Citus
gptkb:CockroachDB
gptkb:NuoDB
gptkb:OpenGauss
gptkb:TimescaleDB
gptkb:YugabyteDB
gptkbp:influencedBy gptkb:Ingres
gptkb:Postgres
gptkbp:latestReleaseVersion 16.2
2024-02-08
gptkbp:license gptkb:PostgreSQL_License
gptkbp:openSource true
gptkbp:operatingSystem Cross-platform
gptkbp:programmingLanguage C
gptkbp:releaseDate 1996-07-08
gptkbp:supports gptkb:JSON
full-text search
SQL
extensibility
replication
concurrency control
ACID transactions
foreign keys
partitioning
stored procedures
triggers
views
window functions
procedural languages
MVCC
spatial data (PostGIS)
table inheritance
gptkbp:website https://www.postgresql.org/
gptkbp:bfsParent gptkb:time_zone
gptkb:fire
gptkb:PERN
gptkbp:bfsLayer 4