Amazon Aurora PostgreSQL supports the pg_bigm extension for faster full text search in AWS GovCloud (US) Regions

Amazon Aurora PostgreSQL-Compatible Edition adds support for the pg_bigm extension in AWS GovCloud (US) regions. pg_bigm extension provides full text search capability in PostgreSQL. This extension allows a user to create *2-gram* (bigram) index for faster full text search.

Characters that comprise text are represented as numbers to computers. Languages such as English, French, Russian, and Hebrew use character sets of fewer than 256 characters that can be encoded in a single byte. Languages with many characters (e.g., Japanese) require more numbers, which are represented by multi-byte encoding. pg_bigm allows you to create a 2-gram (bigram) index for faster full text search of text encoded with multi-byte characters.

You can view a list of all PostgreSQL extensions supported on Amazon Aurora on the AWS User Guide. With this regional expansion, pg_bigm is available in all commercial regions. For full feature parity list, head to our feature parity page, and to see all the regions that support Amazon Aurora head to our region page.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page. To get started with Amazon Aurora, take a look at our getting started page.

Don't see an extension you'd like to use? Let us know through the AWS Forum, through AWS Enterprise support.