Supported Postgres extensions and tools

Cloud Service supports a number of Postgres extensions and tools, which you can install on or alongside your cluster.

• See Postgres extensions available by deployment for the complete list of extensions Cloud Service supports if you're using your own cloud account.

• See Postgres extensions for the list of extensions supported when using EDB Hosted Cloud Service account and for more information on installing and working with extensions.

• Based on your subscription, you may be entitled to a subset of EDB tools that you can access via the EDB Repository. For instructions on using the EDB Repository, see EDB Repository Access.

EDB Postgres extensions and tools

EDB develops and maintains several extensions and tools. These include:

• EDB Advanced Storage Pack — Provides advanced storage options for PostgreSQL databases in the form of table access method (TAM) extensions. These storage options can enhance the performance and reliability of databases without requiring application changes.

  The TAM extensions included in the Advanced Storage Pack include:

  • Autocluster — Provides faster access to clustered data by keeping track of the last inserted row for any value in a side table.

  • Refdata — Can provide performance gains of 5-10% and increased scalability.

• EDB Postgres Tuner — Provides safe recommendations that maximize the use of available resources.

• EDB Query Advisor — Provides index recommendations by keeping statistics on predicates found in WHERE statements, JOIN clauses, and workload queries.

• EDB Wait States — Probes each of the running sessions at regular intervals.

• PG Failover Slots — Is an extension released as open source software under the PostgreSQL License. If you have logical replication publications on Postgres databases that are also part of a streaming replication architecture, PG Failover Slots avoids the need for you to reseed your logical replication tables when a new standby gets promoted to primary.

• Foreign Data Wrappers — Allow you to connect your Postgres database server to external data sources.

• EDB PgBouncer — Allows you to manage your connections to your Postgres database.