Ctrl+K

Use of table access methods (TAMs) in PGD

Use of table access methods (TAMs) in PGD#

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