Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL (B-tree)
Database Blog
This article discusses different types of B-tree indexes and their use cases in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL. It covers the following topics:
- B-tree indexes and their variations like Index Only Scan, range operations, ordering, and pattern matching
- Multi-column indexes
- Partial indexes
- Functional indexes
- Clustering tables on indexes
The article provides examples and explains when each type of B-tree index can be beneficial for improving query performance based on different access patterns and data characteristics.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Jul 17
2024
2024
Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL (GIN, GiST, HASH, BRIN)
Jun 3
2026
2026
Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (Bloom, pg_trgm, and pg_bigm)
Jun 3
2026
2026
Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (SP-GiST, Btree_Gin and Btree_Gist)
Aug 8
2024
2024
Amazon Aurora supports PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.