Creating Aurora PostgreSQL Limitless Database tables

Standard – This is the default table type in Aurora PostgreSQL Limitless Database. You create standard tables using the CREATE TABLE command, and can run Data Description Language (DDL) and Data Manipulation Language (DML) operations on them.

Standard tables aren't distributed tables. They're stored on one of the shards chosen internally by the system.

Sharded – These tables are distributed across multiple shards. Data is split among the shards based on the values of designated columns in the table. This set of columns is called a shard key.

Reference – These tables are replicated on all shards. They're used for infrequently modified reference data, such as product catalogs and zip codes.

Join queries between reference and sharded tables can be run on shards, eliminating unnecessary data movement between shards and routers.

Creating limitless tables by using variables – Use this method when you want to create new sharded and reference tables.

Converting standard tables to limitless tables – Use this method when you want to convert existing standard tables into sharded and reference tables.