---
title: "Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (Bloom, pg_trgm, and pg_bigm)"
url: https://daily.dev/posts/index-types-supported-in-amazon-aurora-postgresql-and-amazon-rds-for-postgresql-using-extensions-bl-irsxjvmon
source_url: https://aws.amazon.com/blogs/database/index-types-supported-in-amazon-aurora-postgresql-and-amazon-rds-for-postgresql-using-extensions-bloom-pg_trgm-and-pg_bigm
type: article
source: "AWS Database Blog"
published: 2026-06-03T15:32:43.668Z
updated: 2026-06-04T02:14:53.765Z
tags: ["aws", "database", "full-text-search", "postgresql"]
reading_time: 12
upvotes: 0
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (Bloom, pg_trgm, and pg_bigm)

**[AWS Database Blog](https://daily.dev/sources/aws-database-blog)** · 12 min read · 0 upvotes · 0 comments

## Summary

Part 4 of a series on PostgreSQL indexing covers three extension-based index types available in Amazon Aurora PostgreSQL and RDS for PostgreSQL. Bloom indexes use probabilistic filters for space-efficient multi-column equality filtering, replacing multiple B-tree indexes with a single lossy index. pg_trgm breaks text into trigrams to enable fuzzy matching, similarity searches, and LIKE/ILIKE pattern matching via GIN or GiST indexes, with tunable similarity thresholds. pg_bigm uses bigrams (2-character sequences) for full-text search in Asian languages like Japanese, Chinese, and Korean that lack whitespace word delimiters. Each extension's use cases, tuning parameters, performance characteristics, and limitations are covered with SQL examples.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://aws.amazon.com/blogs/database/index-types-supported-in-amazon-aurora-postgresql-and-amazon-rds-for-postgresql-using-extensions-bloom-pg_trgm-and-pg_bigm>

## Similar posts on daily.dev

- [Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions \(SP-GiST, Btree\_Gin and Btree\_Gist\)](https://daily.dev/posts/index-types-supported-in-amazon-aurora-postgresql-and-amazon-rds-for-postgresql-using-extensions-sp-crsoycppr) · AWS Database Blog · 0 upvotes · 0 comments
- [Bloom Filters in Postgres: The Index Type Most Developers Overlook](https://daily.dev/posts/bloom-filters-in-postgres-the-index-type-most-developers-overlook-t9ufonv8o) · Prisma Blog · 0 upvotes · 0 comments
- [Amazon Aurora now supports PostgreSQL major version 18](https://daily.dev/posts/amazon-aurora-now-supports-postgresql-major-version-18-f2vatmgdl) · AWS · 5 upvotes · 0 comments

---

Tags: [#aws](https://daily.dev/tags/aws), [#database](https://daily.dev/tags/database), [#full-text-search](https://daily.dev/tags/full-text-search), [#postgresql](https://daily.dev/tags/postgresql)

[View this post on daily.dev](https://daily.dev/posts/index-types-supported-in-amazon-aurora-postgresql-and-amazon-rds-for-postgresql-using-extensions-bl-irsxjvmon)