Note
We are no longer onboarding new users to Citus Cloud on AWS. However, existing customers can continue to use Citus Cloud as they do today.
Extensions¶
To keep a standard Cloud installation for all customers and improve our ability to troubleshoot and provide support, we do not provide superuser access to Cloud clusters. Thus customers are not able to install PostgreSQL extensions themselves.
Generally there is no need to install extensions, however, because every Cloud cluster comes pre-loaded with many useful ones:
Name |
Version |
Schema |
Description |
|---|---|---|---|
btree_gin |
1.2 |
public |
support for indexing common datatypes in GIN |
btree_gist |
1.5 |
public |
support for indexing common datatypes in GiST |
citext |
1.4 |
public |
data type for case-insensitive character strings |
citus |
8.3-1 |
pg_catalog |
Citus distributed database |
cube |
1.2 |
public |
data type for multidimensional cubes |
dblink |
1.2 |
public |
connect to other PostgreSQL databases from within a database |
earthdistance |
1.1 |
public |
calculate great-circle distances on the surface of the Earth |
fuzzystrmatch |
1.1 |
public |
determine similarities and distance between strings |
hll |
2.12 |
public |
type for storing hyperloglog data |
hstore |
1.4 |
public |
data type for storing sets of (key, value) pairs |
intarray |
1.2 |
public |
functions, operators, and index support for 1-D arrays of integers |
ltree |
1.1 |
public |
data type for hierarchical tree-like structures |
pg_buffercache |
1.3 |
public |
examine the shared buffer cache |
pg_cron |
1.0 |
public |
Job scheduler for PostgreSQL |
pg_freespacemap |
1.2 |
public |
examine the free space map (FSM) |
pg_partman |
4.0.0 |
partman |
Extension to manage partitioned tables by time or ID |
pg_prewarm |
1.1 |
public |
prewarm relation data |
pg_stat_statements |
1.5 |
public |
track execution statistics of all SQL statements executed |
pg_trgm |
1.3 |
public |
text similarity measurement and index searching based on trigrams |
pgcrypto |
1.3 |
public |
cryptographic functions |
pgrowlocks |
1.2 |
public |
show row-level locking information |
pgstattuple |
1.5 |
public |
show tuple-level statistics |
plpgsql |
1.0 |
pg_catalog |
PL/pgSQL procedural language |
session_analytics |
1.0 |
public |
|
shard_rebalancer |
8.3 |
public |
|
sslinfo |
1.2 |
public |
information about SSL certificates |
tablefunc |
1.0 |
public |
functions that manipulate whole tables, including crosstab |
topn |
2.1.0 |
public |
type for top-n JSONB |
unaccent |
1.1 |
public |
text search dictionary that removes accents |
uuid-ossp |
1.1 |
public |
generate universally unique identifiers (UUIDs) |
xml2 |
1.1 |
public |
XPath querying and XSLT |