Extensions for PostgreSQL Cluster
PostgreSQL is renowned for its flexibility. You can extend its core functionality with various Extensions.
By default, when you create a database with vDB PostgreSQL, several extensions are already enabled (listed below). You can also manually enable additional extensions as needed.
1. Extensions Enabled by Default
The following extensions are automatically installed on every database in the Cluster upon initialization. You do not need to run CREATE EXTENSION to use them.
plpgsql
1.0
PL/pgSQL procedural language
pg_stat_statements
1.11
Track execution statistics of all SQL statements executed
pg_stat_kcache
2.3.1
Track kernel-level cache statistics (reads, writes) per query
2. Extensions You Can Enable Manually
You can enable the following extensions with CREATE EXTENSION without superuser privileges.
CREATE EXTENSION <extension_name>;btree_gin
1.3
Support for indexing common datatypes in GIN
btree_gist
1.7
Support for indexing common datatypes in GiST
citext
1.6
Data type for case-insensitive character strings
cube
1.5
Data type for multidimensional cubes
dict_int
1.0
Text search dictionary template for integers
dict_xsyn
1.0
Text search dictionary template for extended synonym processing
earthdistance
1.2
Calculate great-circle distances on the surface of the Earth
fuzzystrmatch
1.2
Determine similarities and distance between strings
hstore
1.8
Data type for storing sets of (key, value) pairs
intarray
1.5
Functions, operators, and index support for 1-D arrays of integers
isn
1.2
Data types for international product numbering standards
lo
1.1
Large Object maintenance
ltree
1.3
Data type for hierarchical tree-like structures
pg_partman
5.4.3
Manage time-based and serial-based table partition sets
pg_permissions
1.3
View object permissions and compare them with the desired state
pg_repack
1.5.3
Reorganize tables in PostgreSQL databases with minimal locks
pg_trgm
1.6
Text similarity measurement and index searching based on trigrams
pgaudit
17.1
Provides detailed session and/or object audit logging
pgcrypto
1.3
Cryptographic functions
pltcl
1.0
PL/Tcl procedural language
postgis
3.6.3
PostGIS geometry, geography, and raster spatial types and functions
postgis_raster
3.6.3
PostGIS raster types and functions
postgis_tiger_geocoder
3.6.3
PostGIS tiger geocoder and reverse geocoder
postgis_topology
3.6.3
PostGIS topology spatial types and functions
postgres_fdw
1.1
Foreign-data wrapper for remote PostgreSQL servers
seg
1.4
Data type for representing line segments or floating-point intervals
set_user
4.1.0
Set user session context with optional logging
tablefunc
1.0
Functions that manipulate whole tables, including crosstab
tcn
1.0
Triggered change notifications
timescaledb
2.27.1
Enables scalable inserts and complex queries for time-series data
tsm_system_rows
1.0
TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time
1.0
TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent
1.1
Text search dictionary that removes accents
uuid-ossp
1.1
Generate universally unique identifiers (UUIDs)
vector
0.8.2
Vector data type and ivfflat and hnsw access methods
Last updated