Logo Features for Aurora PostgreSQL

Modified date: Monday, June 30, 2025

Table of Contents

Introduction

In its own words, "Aurora is a relational database management system (RDBMS) built for the cloud with full MySQL and PostgreSQL compatibility".

General

FeatureValueDefinition
introAurora is a relational database management system (RDBMS) built for the cloud with full MySQL and PostgreSQL compatibility.in their own words - but I reserved the rights to remove some bold claims like "the best", unless it is widely recognized.
vendorAmazon AWS

Data Types

FeatureValueDefinition
int: signesssigned onlyif differentiate signed and unsigned int
int: 1-bytes int namen.a.
int: 2-bytes int namesmallint
int: 3-bytes int namen.a.
int: 4-bytes int nameint
int: 8-bytes int namebigint
decimal: storage sizevariable
decimal: rangeup to 131072 digits before the decimal point; up to 16383 digits after the decimal pointalso called number, numeric in different systems
char(n): max bytes10,485,760
text: max bytes1G

SQL

FeatureValueDefinition
basePostgreSQL
SQL: standard complaincehigh
max SQL length

undefined

same as PostgreSQL with "StringInfo" container		maximal SQL statement length
PL: mainSQL + PL/PgSQLmain programming lanage: most database suports SQL because SQL is a well established standard. However, each database would like to extend SQL more or less.
PL: other language supportyesPL lanaguage other than PL/SQL, like PL/Java, PL/Rust etc
SP: max parameters100
UDF: max parameters100
SQL: max parameters65535number of parameters in a PREPARED query
SQL: query hintsGUC onlyif it allows use query hints to guide the optimizer
SQL: explicit lockingyes: row, page, table levelLocking is usually an internal matter - so does it allow explicit locking? What levels do they support?
Triggers?yesIf support triggers
Triggers: scopetables, views, foreign tablesWhat objects can have triggers
Triggers: typeBEFORE, AFTER, INSTEAD OFTypes of triggers supported
Object-Relational?yes
Extension MechanismC programming, link with engine
vector searchno nativedoes it support vector search

Storage and System

FeatureValueDefinition

Benchmarking

FeatureValueDefinition

Tools

FeatureValueDefinition

Export Regulations

FeatureValueDefinition

Internal

FeatureValueDefinition

Internal - Optimizer

FeatureValueDefinition

Internal - Runtime

FeatureValueDefinition

Internal - Storage Engine

FeatureValueDefinition