Use of table access methods (TAMs) in PGD v5

PGD 5.0 supports two table access methods (TAMs) released with EDB Postgres 15.0. These two TAMs were certified and are allowed in PGD 5.0:

• Auto cluster
• Ref data

Any other TAM is restricted until certified by EDB. If you're planning to use any of the TAMs on a table, you need to configure that TAM on each participating node in the PGD cluster. To configure auto cluster or ref data TAM, on each node:

1. Update postgresql.conf to specify TAMs autocluster or refdata for the shared_preload_libraries parameter.
2. Restart the server and execute CREATE EXTENSION autocluster; or CREATE EXTENSION refdata;.

After you create the extension, you can use TAM to create a table using CREATE TABLE test USING autocluster; or CREATE TABLE test USING refdata;. These commands replicate to all the PGD nodes. For more information on these table access methods, see CREATE TABLE.