Supported Postgres extensions
BigAnimal supports a number of Postgres extensions, which you can install on your cluster.
See Postgres extensions available by deployment for the complete list of extensions BigAnimal supports.
See Postgres extensions for more information on installing and working with extensions.
EDB Postgres extensions
EDB develops and maintains several extensions. 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.
Foreign data wrappers
BigAnimal supports enhanced mongo_fdw and mysql_fdw foreign data wrapper extensions. They allow you to connect your Postgres database server to external data sources.
The enhanced versions of the mongo_fdw and mysql_fdw extensions are intended to support additional EDB Postgres Advanced Server capabilities. See:
MongoDB Foreign Data Wrapper — Accesses data that resides on a MongoDB database from a Postgres database server.
MySQL Foreign Data Wrapper — Accesses data that resides on a MySQL database from a Postgres database server.
- On this page
- EDB Postgres extensions
- Foreign data wrappers