> For the complete documentation index, see [llms.txt](https://docs.vngcloud.vn/vng-cloud-document/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.vngcloud.vn/vng-cloud-document/vdb/relational-database-service-rds/postgresql-cluster/vdb-postgresql-cluster-extensions.md). # 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. | Name | Version | Description | | -------------------- | ------- | ------------------------------------------------------------- | | 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. ```sql CREATE EXTENSION ; ``` | Name | Version | Description | | ------------------------ | ------- | -------------------------------------------------------------------- | | 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 | *** --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.vngcloud.vn/vng-cloud-document/vdb/relational-database-service-rds/postgresql-cluster/vdb-postgresql-cluster-extensions.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.