Use of table access methods (TAMs) in PGD
=========================================

The :ref:`EDB Advanced Storage Pack <Using extensions with PGD>`  provides a selection of table access methods (TAMs),
available from EDB Postgres 15.0.

The following TAMs were certified for use with PGD 6.0:

- :ref:`Autocluster <Using extensions with PGD>` 

- :ref:`Refdata <Using extensions with PGD>` 

Usage of any other TAM is restricted until certified by EDB.

To use one of these TAMs on a PGD cluster, the appropriate extension
library (``autocluster`` and/or ``refdata`` ) must be added to the
``shared_preload_libraries`` parameter on each node, and the PostgreSQL
server restarted.

Once the extension library is present in ``shared_preload_libraries`` on
all nodes in the cluster, the extension itself can be created with
``CREATE EXTENSION autocluster;`` or ``CREATE EXTENSION refdata;`` . The
``CREATE EXTENSION`` command only needs to be executed on one node; it
will be replicated to the other nodes in the cluster.

After you create the extension, use
``CREATE TABLE test USING autocluster;`` or
``CREATE TABLE test USING refdata;`` to create a table with the
specified TAM. These commands replicate to all PGD nodes in the cluster.

For more information on these table access methods, see:

- :ref:`Autocluster example <Using extensions with PGD>` 

- :ref:`Refdata example <Using extensions with PGD>`